Excel formula
 

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.

Excel formula
 

Hi,

Try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Baliey" wrote in message
...
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.

Excel formula
 

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

ISERROR will mask all errors and may cause problems.


Gord Dibben MS Excel MVP

On Mon, 5 Oct 2009 18:49:01 -0700, Baliey
wrote:

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.