You don't need the =TRUE, just

=IF(ISERROR(<your vlookup function),"",<your vlookup function)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Aaron" wrote in message
...
=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