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
.