Filter Question

[Jedi Master]

Hello, I am trying to figure out how to bring in an adjacent name value based on multiple criteria with different size arrays. In the sheet below(Daily Report), I simply want to enter a date and have the equipment present a filtered list that meets the following criteria (see screenshot 2, PM Project Tracker): Date=entered date in (Daily Report), & row value in correct date column =1 (PM Project Tracker). Example: If 7/20/2024 were input, I should return Column1 Values for Rows 24 and 25, If 7/21/2024 were input, I should only return Column1 value for Row 24. The current formula I am using that is getting me close is: =IF(ISBLANK(C3),"",FILTER('PM Project Tracker'!B24:B37,SUMPRODUCT(('PM Project Tracker'!M24:UM37=1)*('PM Project Tracker'!M4:UM4='Daily Report'!C3))))..................the ('PM Project Tracker'!M24:UM37=1) is not taking into account the "=1" correctly and still displays both row 24 and 25 values regardless of either date above as input. Perhaps there is a different or better way to achieve this?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(C3="","",FILTER('PM Project Tracker'!B24:B37,XLOOKUP(C3,'PM Project Tracker'!M4:UM4,'PM Project Tracker'!M24:UM37)=1))

 

[Jedi Master]

Hi & welcome to MrExcel.
How about

=IF(C3="","",FILTER('PM Project Tracker'!B24:B37,XLOOKUP(C3,'PM Project Tracker'!M4:UM4,'PM Project Tracker'!M24:UM37)=1))

Thank you so much!!! I knew it was something simple I was missing, and thank you for the welcome and quick response!

 

[Fluff]

You're welcome & thanks for the feedback.