Is there any way to make the array in a MATCH function a variable based on a reference? Or something else to accomplish the same
I know I can use INDIRECT but there's got to be a way to use a reference number of column within array (as is done in VLOOKUP for index column, I want to do for lookup column)...
So instead of:
=INDEX($A:$A,MATCH($B1,$C:$C,0))
I want:
=INDEX($A:$A,MATCH($B1,[Lookup Array Column Number],0))
Edit:
This is the INDIRECT. How long do you wait when excel crashes BTW?
=INDEX('[102615.xlsx]FBA1'!$C:$C,MATCH(ROW()-12,INDIRECT("'[102615.xlsx]FBA1'!$"&CHAR(MATCH(LEFT(RIGHT(B$1,6),5),'[102615.xlsx]FBA1'!$N$1:$U$1,0)+77)&":$"&CHAR(MATCH(LEFT(RIGHT(B$1,6),5),'[102615.xlsx]FBA1'!$N$1:$U$1,0)+77)),0))