Forum Discussion
Solved
Multiple dates in Birthday List
I have a list of birthdays for family & friends and, of course, some have the same date. I use this formula ( =XLOOKUP(E1,F9:F110,B9:B110,"NONE",2)&" "&XLOOKUP(E1,F9:F110,A9:A110," ",2) ) to locate ...
= FILTER(IF({0,1},Name, Age), Birthday=today, "None")
The blue combines the two columns into a 2D range, reversing their order. FILTER then picks out the matching birthdays. You could also add a SORT to list the individuals in age order.
Why do you use XLOOKUP and not FILTER?
XLOOKUP just seemed the easier way to go...never even considered FILTER