Mar 25 2022 01:50 AM - edited Mar 25 2022 01:51 AM
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.
Mar 25 2022 02:19 AM
SolutionMar 25 2022 03:23 AM
@Riny_van_Eekelen Perfect, thank you!
Mar 25 2022 06:38 AM
As variant
=INDEX( XLOOKUP([@['#]]& " Action", Table1[#Headers], Table1), ROW()-ROW(Table1[#Headers]) )
which gives
Mar 25 2022 06:50 AM
You are welcome. One more variant, if column positions are fixed
=@INDEX(Table1,,[@['#]]+1)
as
Mar 25 2022 02:19 AM
Solution