Reputation: 11
OK hoping someone can help.
I have a formula in one cell as follows:
=INDEX($G$2:$R$16,MATCH(A20,$F$2:$F$16,0),MATCH(B20,$G$1:$R$1,-1))
This returns the cell value from a table given the values from another table.
Now I would like a formula to return the cell value that is one cell to the right of the cell that the above formula is referencing.
Any ideas?
Upvotes: 1
Views: 16133
Reputation: 2302
Just shift your array one to the right:
=INDEX($H$2:$S$16,MATCH(A20,$F$2:$F$16,0),MATCH(B20,$G$1:$R$1,-1))
Upvotes: 0
Reputation: 16932
Instead of INDEX(array, row, col) use INDEX(array, row, col+1), i.e., add an +1 in your formula.
Upvotes: 1