Try something like: =IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nyys" wrote in message
...
When using this function I've found that when the function cannot find the
value it's looking for, it returns the #N/A value.

I was wondering if there is a way for it to return a blank cell instead?

I've been plyaing around trying to embed the VLOOKUP in an IF function to
get the blank, but with no luck.

Any suggestions?