Return Multiple Values from IF Statement

[bemp87]

Hi Commnity,

I have a formula I am trying to compile to return to me with who's anniversay date it is from a range of employees and their corresponding hire dates.

I know that a IF statement generally works to find the first TRUE logical evaluation and then stops, but if there are multiple values being searched within a range, how could i get it to return more than one value (potentitially concatenating it as a string)?

Here is what i have so far:

=IF(INDEX($C$2:$C$15,MATCH(TODAY(),C2:C15,0)),INDEX(A2:A15,MATCH(E23,C2:C15,0)))

Any guidance as I would like it to return multiple names from the range if thier hire date = TODAY()

 

[Fluff]

Try
=IFERROR(INDEX($A$2:$A$15,AGGREGATE(15,6,(ROW($A$2:$A$15)-ROW($A$2)+1)/($C$2:$C$15=TODAY()),ROWS($A$1:$A1))),"")

and drag down