I'd review the notes for troubleshooting =vlookup() formulas from Debra
Dalgleish:

http://contextures.com/xlFunctions02.html#Trouble

Rao Ratan Singh wrote:

Sir,

Namaskar! I i just installed office 2007 and some formula is not working and
retruning #N/A and some formula is returning 0 value.

This formula is returing #N/A

=IF(ISBLANK($C1063),"",IF(VLOOKUP($C1063,Inventory _List,9,0)<0,"INVALID
SALE",VLOOKUP($C1063,Inventory_List,9,0)))

and this is returning 0 vlaue

=IF($C1067="","",IF(ISERROR(VLOOKUP($C1067,Invento ry_List,4,FALSE)),0,VLOOKUP($C1067,Inventory_List, 4,FALSE)))

what should i change in excel 2007 or should i unstall office 2007

Hope you will soon solve my problem.

--

Dave Peterson