I have a table where all references to columns are stated as [@[COLUMNNAME]] (I use Excel +2010)
Depending on value in column X, I want to return column 1, 2 or 3 in my lookup. I want to avoid using multiple if statements for this purpose. Instead I want to create a dynamic INDIRECT reference to column.
For example if column priority is "quarter'', it should return Q4-2017 (the reference in Excel is =[@[Quarter key]]. My current indirect reference is
, however it keeps returning error #REF
When I just enter my formula without the Indirect function (just entering ="[@["&[@Priority]&" key]]"), I do get =[@[Quarter key]].
So what am I doing wrong?
Also added extract of file as attachment
https://sheet.zoho.com/sheet/editor...f121d7b851ff7b920cc106ed40003a0c0ae6a6466008b
Depending on value in column X, I want to return column 1, 2 or 3 in my lookup. I want to avoid using multiple if statements for this purpose. Instead I want to create a dynamic INDIRECT reference to column.
![e1fg3JS.png](/board/proxy.php?image=https%3A%2F%2Fi.imgur.com%2Fe1fg3JS.png&hash=a534cd619ee416927da0c4b51aa869ea)
For example if column priority is "quarter'', it should return Q4-2017 (the reference in Excel is =[@[Quarter key]]. My current indirect reference is
Code:
=INDIRECT("[@["&[@Priority]&" key]]")
When I just enter my formula without the Indirect function (just entering ="[@["&[@Priority]&" key]]"), I do get =[@[Quarter key]].
So what am I doing wrong?
Also added extract of file as attachment
https://sheet.zoho.com/sheet/editor...f121d7b851ff7b920cc106ed40003a0c0ae6a6466008b