Match the month and day and return the adjacent cell

[mnsportsfan]

I'm looking for a formula that searches a list of dates to match the month and day to today's current month and day then returns the adjacent cell values.

See attached example.

[Phuocam]

Try this formula in E3 and copy down:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$1:$B$30)/(TEXT($B$1:$B$30,"dd/mm")=TEXT($E$2,"dd/mm")),ROWS($E$3:E3))),"")

[mnsportsfan]

That's perfect, is there a way I can have 2 dates in that formal to find, Match today's date and yesterdays?

[Phuocam]

Yes, it's:

IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$1:$B$30)/
((TEXT($B$1:$B$30,"dd/mm")=TEXT($E$2,"dd/mm"))+(TEXT($B$1:$B$30,"dd/mm")=TEXT($E$2-1,"dd/mm"))),ROWS($E$3:E4))),"")