Forum Discussion
Solved
INDIRECT reference to dynamic table not working
This INDIRECT reference to a dynamic table column doesn't work, what's wrong? It seems to resolve to the correct string? Sample workbook attached.
Riny_van_Eekelen Perfect, thank you!
As variant
=INDEX( XLOOKUP([@['#]]& " Action", Table1[#Headers], Table1), ROW()-ROW(Table1[#Headers]) )which gives
SergeiBaklan Thank you!
You are welcome. One more variant, if column positions are fixed
=@INDEX(Table1,,[@['#]]+1)as
