How to use two cells values to give you the row & column of a cell

2016 views excel
5

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

How do I use a combination of one of the letters and one of the numbers to return the value of the cell that they make up.

ie

If I had a value of d in one cell, and 7 in another cell. How do I find out the what is in D7?

answered question

1 Answer

3

Please try:

=INDIRECT("d"&7)

(INDIRECT is volatile.)

posted this

Have an answer?

JD

Please login first before posting an answer.