VLOOKUP return - #N/A

[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

 

[Aaron]

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

 

[Ron de Bruin]

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

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

 

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

 

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

 

[Beto]

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,

 

[Tim]

Got it now...

Thanks for your help guys

Tim

-----Original Message-----
=IF(ISNA(VLOOKUP(.............)),"",VLOOKUP(...............))

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)




"Tim" <[email protected]> wrote in

message news:[email protected]...

 

[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

 

[Roger]

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