VLookup Return Value

[Kevin]

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!

 

[tjtjjtjt]

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

 

[Max]

One way ..

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

 

[Kevin]

Thankyou!

Kevin

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

 

[tjtjjtjt]

Your welcome. Thanks for the feedback.

tj

Thankyou!

Kevin