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!