VLOOKUP return - #N/A

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
=IF(ISNA(VLOOKUP(.............)),"",VLOOKUP(...............))

This will return a empty cell if the Vlookup returns a #N/A error.
 
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)
 
=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))
 
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,
 
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
 
=if(iserror(vlookup(BO9,'Employee List'!
A1:B240,2)),"",VLOOKUP(BO9,'Employee List'!A1:B240,2))
 
Back
Top