=IF(ISERROR(<your vlookup function)=TRUE,"",<your vlookup function)
"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