Forum Discussion
Index Match formula where the match searches multiple columns
Hi, I am comparing two tabs to find matching items and then return information from certain columns, and I will typically use Index Match for this sort of exercise. The issue I am dealing wi...
MATCH does not work with a range of more than one row and column.
Try this (it is an ordinary formula):
=INDEX(Sheet1!A2:A5000,SUMPRODUCT((Sheet1!B2:E5000=A2)*(ROW(Sheet1!A2:A5000)-ROW(Sheet1!A1))))