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

Question

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?

pnuts · Accepted Answer · 2018-11-06T13:01:47.717

3

Please try:

=INDIRECT("d"&7)

(INDIRECT is volatile.)

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

edited Nov 06 '18 at 13:01

answered Nov 06 '18 at 12:58

pnuts

But the value of D and 7 are going to change. D could be A-Z, 7 could be 1-100. Thanks – WhiteFeather Nov 06 '18 at 12:59

score 2 · Answer 2 · answered Nov 06 '18 at 13:03

2

You can make a reference to both.

=INDIRECT(B1&B2)

answered Nov 06 '18 at 13:03

Wizhi

2 Answers2