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!

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!

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!

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!

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!