Forum Discussion
Index & Match Formula Not Working
In broad terms, I'm on sheet 2 and wanting to show the contents of a cell from sheet 1. Basically, I want whatever is in column C of sheet 1 for the row that has column A in Sheet 1 matching A2 in S...
Maybe it was just the 0 missing from the MATCH to required exact matches.
With 365 I would use array formulas and truncate entire column references to conform to the actual data.
= INDEX(returnArray, XMATCH(TRUE, BYROW(lookupArrays=lookupValues, AND)))
or
= XLOOKUP(TRUE, BYROW(lookupArrays=lookupValues, AND), returnArray)