Lookup multiple criteria

[dangerousdaveeg]

Hello

I have looked online and tried multiple different suggestions but I must be doing something wrong as I cant get the desired result.

What I want to do is.

In cell A60 is a Data validation list derived from all of the names in cells A2:A55
In cell A61 I wanted a formula to look for the name from A60 within the range A2:A55 and then look for any instance of the number 1 within range B2:AE55 and for every match of the number 1 I wanted to return the dates they relate to that is in range B1:AE1

Below is a screenshot of the data that hopefully helps with what I want to achieve, So as an example I would want the end result to show 5/2/2022 & 26/2/2022

Thanks

Dave

 

[Toadstool]

...some users are only going to use it in google sheets and that does not support the Aggregate function, unfortunately.
Thanks for the help

You're welcome.
My advice would be to switch exclusively to Google Sheets as you'll find more such occurrences needing double maintenance as you add functionality.