Multiple dates in Birthday List

[dlcartin]

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!!!

[#2]

Why do you use XLOOKUP and not FILTER?

[#3]

XLOOKUP just seemed the easier way to go...never even considered FILTER

[#4 · Accepted solution]

@dlcartin 

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

[#5]

Thanks, but it keeps giving me a SPILL error.

[#6]

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