Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 4th 04, 05:11 PM posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 105
Default 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

  #2   Report Post  
Old February 4th 04, 05:18 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 3
Default 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



  #3   Report Post  
Old February 4th 04, 05:22 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,123
Default 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



  #4   Report Post  
Old February 4th 04, 05:23 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2003
Posts: 11,272
Default 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





  #5   Report Post  
Old February 4th 04, 05:28 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 27,285
Default 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





  #6   Report Post  
Old February 4th 04, 06:23 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2003
Posts: 140
Default 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.

  #7   Report Post  
Old February 4th 04, 06:31 PM posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2004
Posts: 105
Default 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



.

  #8   Report Post  
Old February 4th 04, 07:03 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 1
Default 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

  #9   Report Post  
Old February 5th 04, 02:10 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2004
Posts: 1
Default 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
.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Vlookup then interpolate,return corresponding value, if not, return other value Wzaman Excel Worksheet Functions 1 December 14th 10 02:17 AM
Vlookup return Zero if not there Troy[_2_] Excel Worksheet Functions 2 December 10th 09 04:36 PM
VLookUp - Does the VLookUp return the exact information? Cpviv Excel Worksheet Functions 2 October 28th 08 10:57 AM
Vlookup - return row no. instead of value automne Excel Discussion (Misc queries) 2 March 7th 05 01:38 AM
VBA Syntax for VLOOKUP to return array of return values Alan Beban[_3_] Excel Programming 7 August 5th 03 11:41 AM


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017