INDIRECT reference to dynamic table not working

[bartvana]

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.

[#2 · Accepted solution]

@bartvana This way.

[#3]

@Riny_van_Eekelen Perfect, thank you!

[#4]

@bartvana 

As variant

=INDEX( XLOOKUP([@['#]]& " Action", Table1[#Headers], Table1), ROW()-ROW(Table1[#Headers]) )

which gives

[#5]

@Sergei Baklan Thank you!

[#6]

@bartvana 

You are welcome. One more variant, if column positions are fixed

=@INDEX(Table1,,[@['#]]+1)

as