INDEX MATCH MATCH to OTHER WORKSHEET
I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets.
How do I reference the columns as a range and a value?
The formula should be as follows:
(in cell B2) =INDEX(Sheet1!,MATCH($A2,Sheet1!$A:$A,0),MATCH(B$2,Sheet1!$B:$B,0))
An INDEX(MATCH) or VLOOKUP for each individual column is not an acceptable answer as there are tens and tens of columns :)