user2809998
user2809998

Reputation: 11

Excel formula to return value in a cell to the right

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

Answers (2)

unique2
unique2

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

Christian Fries
Christian Fries

Reputation: 16932

Instead of INDEX(array, row, col) use INDEX(array, row, col+1), i.e., add an +1 in your formula.

Upvotes: 1

Related Questions