=IF(ISNA(vlookup_formula),"",vlookup_formula)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Richard" wrote in message
...

The normal vlookup function returns a NA if the table_array doesn't
contain
the lookup_value.

Can you help me write a new function that returns a blank or "" instead?


--
Richard