| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If Statement "FALSE" Return | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| "If" statement returning blank gives downstream formula errors. | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Formula Returning "FALSE" | Excel Worksheet Functions | |||
Threaded Mode
