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.
5 Replies
Riny_van_Eekelen Perfect, thank you!
As variant
=INDEX( XLOOKUP([@['#]]& " Action", Table1[#Headers], Table1), ROW()-ROW(Table1[#Headers]) )which gives
