index match with a set of data (2 dimensional match)
I am trying to use index match but my match is using a range of data (not just 1 column, but many). This causes the match function to return a 2d number relative to the row/column matched and not just a row number. It seems index is expecting just a row number (and optional 3rd parameter for column) and this does not work together.
How can I get index match to work when match is returning a 2-dimensional result to the index function?
Help Article Resources
Check out the Formula Handbook template!