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() works with 1D array only. If in the same row value appears only one time in any of columns, formula could be
=IFNA(INDEX('sheet1'!A2:A5000,
match(1,
INDEX(
(sheet2!A2='sheet1'!B2:B5000,0)+
(sheet2!A2='sheet1'!C2:C5000,0)+
(sheet2!A2='sheet1'!D2:D5000,0)+
(sheet2!A2='sheet1'!E2:E5000,0), 0
), 0
),"no such")