SOLVED

INDIRECT reference to dynamic table not working

Frequent Contributor

This INDIRECT reference to a dynamic table column doesn't work, what's wrong?

bartvana_0-1648197895872.png

It seems to resolve to the correct string?

bartvana_1-1648197930786.png

Sample workbook attached.

5 Replies
best response confirmed by bartvana (Frequent Contributor)
Solution

@bartvana This way.

Riny_van_Eekelen_0-1648199945100.png

 

@bartvana 

As variant

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

which gives

image.png

@bartvana 

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

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

as

image.png