Hi Rog,

=IF(ISNA(VLOOKUP(C1,A1:B5,2,0)),"",(VLOOKUP(C1,A1: B5,2,0)))

=IF(ISNA(VLOOKUP(C1,A1:B5,2,0)),"Not Found",(VLOOKUP(C1,A1:B5,2,0)))

HTH
Regards,
Howard

"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