VLOOKUP return - #N/A
 

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

VLOOKUP return - #N/A
 

=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

VLOOKUP return - #N/A
 

=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)
www.rondebruin.nl



"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

VLOOKUP return - #N/A
 

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

VLOOKUP return - #N/A
 

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

--
Regards,
Tom Ogilvy

"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

VLOOKUP return - #N/A
 

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.

VLOOKUP return - #N/A
 

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)
www.rondebruin.nl



"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


.

VLOOKUP return - #N/A
 

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

--
Message posted from http://www.ExcelForum.com

VLOOKUP return - #N/A
 

=if(iserror(vlookup(BO9,'Employee List'!
A1:B240,2)),"",VLOOKUP(BO9,'Employee List'!A1:B240,2))
-----Original 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
.