Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Kevin
 
Posts: n/a
Default VLookup Return Value

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!
  #2   Report Post  
tjtjjtjt
 
Posts: n/a
Default

So, you want to suppress the #NA Error?
You can try this:
=IF(ISNA(Your_VLOOKUP),"",YourVLOOKUP)
an example would look something like this:
=IF(ISNA(VLOOKUP(E6,$I$8:$J$10,2,0)),"",VLOOKUP(E6 ,$I$8:$J$10,2,0))

tj

"Kevin" wrote:

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!

  #3   Report Post  
Max
 
Posts: n/a
Default

One way ..

Try with an error trap :
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

--
Rgds
Max
xl 97
--
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
---
"Kevin" wrote in message
...
I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If

it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!



  #4   Report Post  
Kevin
 
Posts: n/a
Default

Thankyou!

Kevin

"tjtjjtjt" wrote:

So, you want to suppress the #NA Error?
You can try this:
=IF(ISNA(Your_VLOOKUP),"",YourVLOOKUP)
an example would look something like this:
=IF(ISNA(VLOOKUP(E6,$I$8:$J$10,2,0)),"",VLOOKUP(E6 ,$I$8:$J$10,2,0))

tj

"Kevin" wrote:

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!

  #5   Report Post  
tjtjjtjt
 
Posts: n/a
Default

Your welcome. Thanks for the feedback.

tj

"Kevin" wrote:

Thankyou!

Kevin

"tjtjjtjt" wrote:

So, you want to suppress the #NA Error?
You can try this:
=IF(ISNA(Your_VLOOKUP),"",YourVLOOKUP)
an example would look something like this:
=IF(ISNA(VLOOKUP(E6,$I$8:$J$10,2,0)),"",VLOOKUP(E6 ,$I$8:$J$10,2,0))

tj

"Kevin" wrote:

I am trying to use VLookup to retrieve a value from a table I have already
established. The lookup will always return a value. This is expected. If it
does not find an appropriate value I don't want it to return anything.
Currently the lookup is returning #N/A if it finds nothing. I would prefer
that it not display anything. How can I do this?

Thanks in advance!

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
Can vlookup return multiple matches in a single cell? cchristensen Excel Discussion (Misc queries) 3 December 2nd 04 02:56 AM
VLOOKUP, I think Matt T Excel Worksheet Functions 1 November 18th 04 08:07 PM
VLOOKUP not working Scott Excel Worksheet Functions 3 November 12th 04 09:06 PM
How to look up and return multiple values Wendy Excel Worksheet Functions 3 November 3rd 04 05:32 PM
vlookup and IF function cambridge Excel Worksheet Functions 5 October 28th 04 08:29 PM


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

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

About Us

"It's about Microsoft Excel"