VLOOKUP return - #N/A
=if(BO9="","", VLOOKUP(BO9,'Employee List'!A1:B240,2))
if you want to suppress the fact that a match is not made
=if(isna( VLOOKUP(BO9,'Employee List'!A1:B240,2)),"", VLOOKUP(BO9,'Employee
List'!A1:B240,2))
--
Regards,
Tom Ogilvy
"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
|