Rog,

Test for it

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...)))


--

HTH

Bob Phillips

"rog" wrote in message
...
If there is not matching values, VLOOKUP returns "#N/A". How can I prevent
this error value to be displayed
Thanks