Excel 365 filter formula: Return records in the column based on its header's text value

[Tenmakk]

I know this is the criteria for the Filter function in Excel 365: =FILTER(array,include,[if_empty])

I want to return results based the text in a column header. I won't know the column name (for example, if I want to search for the column with the "Person" header, the column number could change (the "Person" column could be C2, or E2, or something else)

Can the "Include" criteria use Match? Something like. I'm having difficulty getting it to work:

=FILTER(A1:F100, COLUMN( MATCH( "Person"), "--")

Thank you

[Gregb11]

1. It's always best to attach a sample file with mocked up answers. See the Yellow banner at the top for more info.
2. If you are using MS365 now, please update your profile

3. Let's say you had an array you wanted to filter and this array was B2:E4 and B1 had the Headers, where one is = "Person" If you wanted to filter the array for just the rows where the value under "Person" was "test", you could use this:

=FILTER(B2:E4,INDEX(B2:E4,,MATCH("Person",B1:E1,0))="test")

See attached.