Hi --
Is it possible to create an indirect formula referencing only a single cell within a formatted table?
I have a table with rates by month, and I want a column that always shows the rates for whatever month is input in a cell.
The headers are in YYYY-MM format.
Example: If I wanted the column to pull the rates from the 2018-08 column, the normal formula would be '=[@[2018-08]]'.
However, when I try to make this an indirect formula (with the '2018-08' referenced in cell B2, lets say), I get an error.
Is there a way to make this work?
(fyi, each line has a unique value in column [Person]; just in case you think there's a different way to get to what I'm looking for, vs just a single cell reference)
Thank you!
Bookmarks