ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VLOOKUP (https://www.excelbanter.com/excel-programming/272116-re-vlookup.html)

L. Howard Kittle[_2_]

VLOOKUP

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

All times are GMT +1. The time now is 02:11 AM.