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

2016 views excel

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.


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


Please try:


(INDIRECT is volatile.)

posted this

Have an answer?


Please login first before posting an answer.