Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
VLOOKUP, I think | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions | |||
How to look up and return multiple values | Excel Worksheet Functions | |||
vlookup and IF function | Excel Worksheet Functions |