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.