Reto E.
Reto E.

Reputation: 119

Excel replace column name with cell value in formula

I want to replace a columnname with a cell value in a formula:

enter image description here

Seems like a simple problem, but I can't find the right way to dynamically (based on another cell value) create the column name for the formula.

Upvotes: 0

Views: 758

Answers (1)

Scott Craner
Scott Craner

Reputation: 152660

Use INDIRECT:

=INDIRECT("table[@"&E1&"]")

Upvotes: 1

Related Questions