Here's a simplified example of what I'm trying to do:
Table: Data has columns based by month name
Cell B1 contains a list of the the columns in table Data.
I'm trying to build a formula that basically says: take the value from the nth row of table Data, in the column listed in cell B1 (which isn't contained within the table).
I'm using the drop down list in other places and would like to automate it so that I can just select the month and everything will in.
Table: Data has columns based by month name
Cell B1 contains a list of the the columns in table Data.
I'm trying to build a formula that basically says: take the value from the nth row of table Data, in the column listed in cell B1 (which isn't contained within the table).
I'm using the drop down list in other places and would like to automate it so that I can just select the month and everything will in.