CODEWITHSUNDEEP
excelexcel-formulareferenceexcel-indirect
WhiteFeather
WhiteFeather

Reputation: 65

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

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?

Upvotes: 4

Views: 1758

Answers (2)

Wizhi
Wizhi

Reputation: 6549

You can make a reference to both.

=INDIRECT(B1&B2)

enter image description here

Upvotes: 2

pnuts
pnuts

Reputation: 59495

Please try:

=INDIRECT("d"&7)

(INDIRECT is volatile.)

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

Upvotes: 3

Related Questions