vlookup if statement returning a "false" answer.

[inthestands]

I am vlooking up costs to enter into my spreadsheet. In column I is my
current cost. In column J is my last cost. If we are out of inventory, our
computer gives us a 0 cost in current. When this happens I want the last
cost to be reported in it's place. My formula will give me the last cost
correctly, but it returns a "false" answer instead of the current cost.
Could you please correct my formula.

=IF(VLOOKUP(D2,'NEW DATA'!$A$11:$J$5500,9,0)=0,(VLOOKUP(D2,'NEW
DATA'!$A$11:$J$5500,10,0)))


thanks in advance,

inthestands

 

[JE McGimpsey]

One way:

=IF(VLOOKUP(D2,'NEW DATA'!$A$11:$J$5500,9,0)=0, VLOOKUP(D2,'NEW
DATA'!$A$11:$J$5500,10,0), VLOOKUP(D2,'NEW DATA'!$A$11:$J$5500,9,0))

 

[inthestands]

Thank you, great answer, it works great... very much appreciated!!