ExcelBanter - VLOOKUP

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

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

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

Bob Phillips[_5_]

VLOOKUP

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

All times are GMT +1. The time now is 01:15 AM.