Tim wrote:

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

You could try:

=IF(ISNA(VLOOKUP(BO9,'Employee
List'!A1:B240,2)),"",VLOOKUP(BO9,'Employee List'!A1:B240,2))

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.