On my sheet there are several user inputs that are fed into a specific table (there are 33) using simple Index(Match())'s depending on the inputs to generate the desired outputs. I have everything set up out to my final outputs and I am stuck. Right now I have an output table of single cell arrays where an example cell contains the function:
{=INDEX($AD$103:$AD$111,N(IF({1},MATCH(N2:N100,$AC$103:$AC$111,0))))}
which returns a single column array of {1,2,3...,n}
Each cell on this table contains unique outputs.
I need to output a specific element of the array of the desired cell of the output table at an index equal to the input record (i.e.: row 1 returns element 1 of a specific cell of the output table)
Right now for my output cell I have:
=INDEX($BR$103:$BR$135,MATCH(R2,$BQ$103:$BQ$135,0))
which returns the first element of the desired cell on the output table. How can I modify this formula or create a new one that can pull the desired element from the referenced cell?
The goal here is the not have to store 33(number of tables) * 5(number of desired outputs per record) * 100(number of records) on a cell by cell basis.
Is this possible? Happy to provide further details.
Bookmarks