ExcelBanter - REMOVE #N/A

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - REMOVE #N/A (https://www.excelbanter.com/excel-worksheet-functions/16964-remove-n.html)

Peter

REMOVE #N/A

When using the VLOOKUP function, and the formula can not find the reference
field in the array table, then it returns #N/A.

How can I write a statement to make it dissapear?

Thanks,
Peter

Peter

Please Disregard!!!!
I got it.
Peter

"Peter" wrote in message
...
When using the VLOOKUP function, and the formula can not find the
reference field in the array table, then it returns #N/A.

How can I write a statement to make it dissapear?

Thanks,
Peter

All times are GMT +1. The time now is 09:57 AM.