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!