vlookup if statement returning a "false" answer.
 

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

vlookup if statement returning a "false" answer.
 

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))


In article ,
inthestands wrote:

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

vlookup if statement returning a "false" answer.
 

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


"JE McGimpsey" wrote:

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))


In article ,
inthestands wrote:

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