Idex Match

Occasional Visitor

Hi Guys,


Im trying to do an index match on the below data to try and look up from the description in column J to match what's in columns B/C and to return the item in column A.


The formulas seems to work and pulls in the correct info. however if column B is blank the data just pulls in the wrong data and duplicates it.



Could anyone advise or maybe tell me a better way to look up the data in column J to B/C?




2 Replies
Please post an Excel file rather than screen-shots, we don't like re-entering your data. Make sure the workbook does not contain any sensitive information.


Adjust the ranges as needed, but don't use entire columns in the following formula.