VLOOKUP return - #N/A

T

Tim

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
 
R

Ron de Bruin

=IF(ISNA(VLOOKUP(.............)),"",VLOOKUP(...............))

This will return a empty cell if the Vlookup returns a #N/A error.
 
B

Bob Phillips

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)
 
T

Tom Ogilvy

=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))
 
B

Beto

Tim said:
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
Click to expand...

You could try:

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

Regards,
 
A

abxy

Just so you know, as an alternative to the other replies, you can us
the IF function. for example:

IF(A1="", "", VLOOKUP(*your Vlookup criteria*))

lol, oh wait, that was already suggested, wasn't it
 
R

Roger

=if(iserror(vlookup(BO9,'Employee List'!
A1:B240,2)),"",VLOOKUP(BO9,'Employee List'!A1:B240,2))
 
Top