SOLVED

Contributor

# 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 a name that matches TODAY() (E1) AND the year they were born in (to display their age). My question is how do I modify the formula to find multiple, or all, dates the meet the criteria? Thanks in advance!!!

5 Replies

# Re: Multiple dates in Birthday List

Why do you use XLOOKUP and not FILTER?

# Re: Multiple dates in Birthday List

XLOOKUP just seemed the easier way to go...never even considered FILTER
best response confirmed by dlcartin (Contributor)
Solution

# Re: Multiple dates in Birthday List

= 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.

# Re: Multiple dates in Birthday List

Thanks, but it keeps giving me a SPILL error.

# Re: Multiple dates in Birthday List

UPDATE: I got the SPLL error worked out. It's working fine....THANK YOU!!!