If DATE(B2) behind NAME(A2) matches TODAY, then return name in D2.

[MervynR]

Hey

Basically if any cell from B=TODAY(), then it should return name from A to cell D2.
Tried using =IF(B2=TODAY();A2;""), but it only works for A2 and B2 cells. $B$2 and $A$2, and B:B A:A do not work either.
One of the formulas worked but it extended my D2 cell longer D2:D8 but I only need info in D2.

namedate.png

[FDibbins]

Maybe something like...

=index(A1:A8,match(today(),B1:B8,0))

[MervynR]

I believe that worked, thanks a bunch

[FDibbins]

Happy to help and thanks for the feedback