Use a cell reference to update a filter command

[lionelR61]

Good afternoon,
I need to be able to change the filter range by referencing a single cell BN2 = [Jan 23].
The difficulty is the table reference, FeesInvoice[ x ]

(Cell Reference BM4) =FILTER(FeesInvoiced[Project Number],FeesInvoiced[Jan-22]<>0)
(Cell Reference BN4) =FILTER(FeesInvoiced[Jan-22],FeesInvoiced[Jan-22]<>0)

Jan-22 needs to be dynamic, I cannot get the syntax correct.
Any assistance would be appreciated.

 

[Georgiboy]

As the headers in the table will be text but the value in BN3 could be a date as Excel would format Jan-23 as a date on my machine the below may help:

=FILTER(FeesInvoiced[Project Number],INDEX(FeesInvoiced,,MATCH(TEXT($BN$3,"mmm-yy"),FeesInvoiced[#Headers],))<>0)

 

[lionelR61]

Georgiboy, thank you very much that is excellent logic.
I am however struggling with geting the account values in the second column, what is the syntex for moving across the table to column 'Jan 22"

=FILTER(FeesInvoiced[Jan-22],FeesInvoiced[Jan-22]<>0)

Apologies if it is obvious

 

[lionelR61]

I tried this but errored
=FILTER(FeesInvoiced,MATCH(TEXT($BN$3,"mmm-yy"),FeesInvoiced,MATCH(TEXT($BN$3,"mmm-yy")),<>0))

 

[Georgiboy]

The 0 just before the <>0 needs to be added to the first formula:

=FILTER(FeesInvoiced[Project Number],INDEX(FeesInvoiced,,MATCH(TEXT($BN$3,"mmm-yy"),FeesInvoiced[#Headers],0))<>0)

Maybe the below for the second:

=let(c,INDEX(FeesInvoiced,,MATCH(TEXT($BN$3,"mmm-yy"),FeesInvoiced[#Headers],0)),filter(c,c<>0))

 

[lionelR61]

Georgiboy
That's excellent and it worked thank you very much.