How to use two cells values as row and column coordinates for referencing another cell?

user_8628356 0
Viewed 992

I have a range of cells containing numbers, and a range of cells containing letters.

E.g. if I had a value of d in one cell, and 7 in another cell, how would I get the value of cell D7?

How do I use a combination of one of the letters and one of the numbers to reference another cell and get its value?

excel-indirect excel-formula excel reference
2 Answers

Please try:

=INDIRECT("d"&7)

(INDIRECT is volatile.)

Use cell references (not stated) if you want not to hard code.

user_15051200

You can make a reference to both.

=INDIRECT(B1&B2)

enter image description here

user_45525290
Related