Excel replace column name with cell value in formula-CodePudding

Home > Software engineering > Excel replace column name with cell value in formula

Excel replace column name with cell value in formula

Time：12-23

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

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.

Thanks for any hints

Reto

CodePudding user response：

Use INDIRECT:

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