ExcelBanter - To deal with #NA

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

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

- - To deal with #NA (https://www.excelbanter.com/excel-worksheet-functions/262595-deal-na.html)

Amin

To deal with #NA

i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.

ozgrid.com

To deal with #NA

see http://www.ozgrid.com/Excel/stop-na-vlookup.htm

--
Regards
Dave Hawley
www.ozgrid.com
"Amin" wrote in message
...
i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.

Jacob Skaria

To deal with #NA

One wa is to use ISNA() IF() combination to handle the error

=IF(ISNA(vlookupformula),"",vlookupformula)

--
Jacob (MVP - Excel)

"Amin" wrote:

i want to stop the #N/A showing in my cells where the VLookup has been used
is it possiblt to stop them from showing when a a lookup value is not yet
available.

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