Excel formula

[Baliey]

Currently I have created a formula using Index & Match, to use a product code
and match it to a product code in an array of data and return the data in a
specific column. All is working well however there are some product codes I
am looking up that do not yet exist in the array of data, and therefore the
formual answer is #N/A. What can I add to the formula to stop this from
happening. I was thinking of an IF statment. The array of data is an excel
spreadsheet that is automatically updated from our accounting system.

 

[Ashish Mathur]

Hi,

Try this

=if(iserror(your_formula),"",your_formula)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Gord Dibben]

=IF(ISNA(formula,""),formula)

ISERROR will mask all errors and may cause problems.


Gord Dibben MS Excel MVP