Not sure if this is the way to work this for a good solution:
I have the following formula in each cell
CW57 - =INDEX(E$4:E$21,MATCH($A53,$A$4:$A$21,0))
CX57 - =INDEX(N$4:N$21,MATCH($A53,$A$4:$A$21,0))
CY57 - =INDEX(W$4:W$21,MATCH($A53,$A$4:$A$21,0))
Etc.. I need a quicker way to get the results from the columns as I add more data, so as you see E column to N column (is 9 columns and so on each column result needed is 9 columns along)
so I don't need to manually change the column for result letter each time I drag the formula across 1 cell?
Would OFFSET work in to this folrmula?
If it helps, the results looked up for are all values (e.g. £585.56)
I have the following formula in each cell
CW57 - =INDEX(E$4:E$21,MATCH($A53,$A$4:$A$21,0))
CX57 - =INDEX(N$4:N$21,MATCH($A53,$A$4:$A$21,0))
CY57 - =INDEX(W$4:W$21,MATCH($A53,$A$4:$A$21,0))
Etc.. I need a quicker way to get the results from the columns as I add more data, so as you see E column to N column (is 9 columns and so on each column result needed is 9 columns along)
so I don't need to manually change the column for result letter each time I drag the formula across 1 cell?
Would OFFSET work in to this folrmula?
If it helps, the results looked up for are all values (e.g. £585.56)