Associated Rows Excel

[mtorpy]

I would like to designate the name of a cell as “column_name,” and then enter the letter equivalent of a variable column in the column_name cell. In a “Report Cell,” I would like to use excel to identify the value the variable column_name in combination with an absolute row number to have the Report Cell display the value located in the particular variable cell.

For example, I am interested in using the Report Cell to display values of various columns associated with Row 6. In cell C6, the value is 250, and in cell D6 the value is 345.

So, if I want to see the value of cell, C6 in the Report Cell, I would enter “C” in the column_name cell, and there would be a function in the Report Cell that directs Excel to report the value of 250. Subsequently, I would enter D in the column_name cell and I would automatically read 345 in the Report Cell.

The question, what is the form of the function that would be used in the Report Cell, and can you provide an example (if such a function exists).

 

[AnotherHiggins]

No problem. Have a look at the INDIRECT function.

For your purposes:
[COLOR=blue white]=INDIRECT(A1&"6")[/color]

Type c in A1 and the function will return 250, change A1 to d and watch the returned value change to 345.

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.