I have a table and am using the =filter formula to create lists from the table. My question - is it possible to trick the filter syntax to see a #$#$ reference (in another cell) as the header reference?
I.e. instead of
I want to substitute the [EOS300]] reference with text in, say, $A$5.
Note - the text in $A$5 will contain a valid name - I just want to be able to drag the formula.