View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default VLOOKUP return - #N/A

Got it now...

Thanks for your help guys

Tim


-----Original Message-----
=IF(ISNA(VLOOKUP(.............)),"",VLOOKUP(..... ..........))

This will return a empty cell if the Vlookup returns a

#N/A error.


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Tim" wrote in

message ...
I using =VLOOKUP(BO9,'Employee List'!A1:B240,2).
Is there away to have the cell remain blank if nothing is
entered. As it is #N/A, shows up in the cell

Zero Value is turned off

Thanks
Tim



.