Hi All,

So I have created a table in excel using the format as table tool.
In a cell I want to reference data from other cells in the row.
However which column it references it from is dependent on a criteria. This criteria is located in a cell outside of the table.
So for example there could be columns "A (Name)" "B (Name)" and "C (Name)"
So in the cell outside the table I would put "A" as the value
So to reference the A column cell the formula would be "[@[A (Name)]]"
How can you tell excel to look at the outside cell (e.g. F1) for the first part of the column header name? i.e. "[@[F$1 (Name)]]"

Hopefully this makes sense