please help give me the formula

[ricardo2260]

I have tried using several formulas that I know, but they still don't work well, please help

I want to make sheet 2 a search sheet, while sheet 1 is a collection of existing data

for example, I want to see who the members of A are on 01-01-2025, and B,C,D etc.

Please help

[#2]

@ricardo2260 

It's not totally clear what you are wanting your "search" sheet to display, but let me refer you to the FILTER function. Here is a web page that explains it. Here's a YouTube video that explains it.

If that doesn't work for you, perhaps you could come back with a more complete description of the need and why FILTER didn't work.