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

​I have tried using several formulas that I know, but they still don’t work well, please helpI want to make sheet 2 a search sheet, while sheet 1 is a collection of existing datafor example, I want to see who the members of A are on 01-01-2025, and B,C,D etc.Please help    Read More

​