My Vlookup is like below, but I'm finding that it doesn't seem to go to the Cost pull tab to get the data .. I found it says No Cost when there is a cost in the cell. What have I done missed in the formula? FYI, this is my first attempt at something like this. Appreciate the input.

=IFERROR(VLOOKUP(LEFT(C:C,20),'Item Cost'!A:B,2,0),IFERROR(VLOOKUP(LEFT(C:C,20),'Cost pull from backend'!A:E,5,0),"No Cost"))