Help with Let/Filter Formula

[ozzborn]

I am using Excel 365.
I cannot use mini-sheets, because of security reasons.

What I am trying to accomplish is write a formula that uses the table to the right as the array. I want it to return only the last and first names of the people that have amounts due.
The right hand table is named "last". I want it to report to the left columns "Last", "First", and "Due"

I tried =LET(f,FILTER(,((Last[Due]>=1)*(Last[Due]<=9000)),""),IF(f="","",f))

I tired =FILTER(List,((Last[Due]>=1)*(Last[Due]<=9000)),"")

I am open to other formulas.

I used the above formulas before and tried to adapt them. I am not very experienced with this so I am sure I messed it up.

Thanks
Ozz

 

[Cubist]

Try:

=FILTER(Last,Last[Due]>0)

 

[ozzborn]

Thank you, that was way simpler than expected.