Get value for alterantive names

Hey,

I need to return the original name for alternative names.

As long as you don't have too many names

=INDEX(A:A,SUMPRODUCT(($B$2:$D$4=H2)*ROW($B$2:$B$4)))

Thank you for the fast solution.

Can I add something to return "" if the value from the list doesnt exist in array.

By too many names you mean too much rows or columns?

I just meant if it gets slow

=IF(SUMPRODUCT(($B$2:$D$4=H2)*ROW($B$2:$B$4))>0,INDEX(A:A,SUMPRODUCT(($B$2:$D$4=H2)*ROW($B$2:$B$4))),"")

Hi, to all!

Another option could be:
[I2] : =IF(COUNTIF(B$2:D$4,H2),INDEX(A$2:A$4,AGGREGATE(15,6,ROW(B$2:D$4)-ROW(B$1)/(B$2:D$4=H2),1)),"")

And drag it down. Blessings!