Hey everyone,
I'm trying to write a formula where I can dynamically give a column reference based on the selection criteria.
For example, if the column selected is Alpha, the cell reference should be "C2" in the data set sheet
If the column selected is Beta, the cell reference should be "D2" in the data set sheet
Output (Sheet 1) -
Data set (Sheet 2)-
I'm trying to write a formula where I can dynamically give a column reference based on the selection criteria.
For example, if the column selected is Alpha, the cell reference should be "C2" in the data set sheet
If the column selected is Beta, the cell reference should be "D2" in the data set sheet
Output (Sheet 1) -
Data set (Sheet 2)-