Search for duplicate values-Excel

How to return a company based on a value, even if the array has several duplicates. Can return the first found.

insert the description of the image here

Author: Bruno Souza, 2019-07-24
Source

1 answers

I solved using the matrix function:

{=SEERRO(ÍNDICE($A$1:$C$1;;MENOR(SE((COL($A$2:$C$5)-COL($A$2)+1)*($A$2:$C$5=$F$2)=0;99;(COL($A$2:$C$5)-COL($A$2)+1)*($A$2:$C$5=$F$2));COL(B1)));"")}

 1
Author: Bruno Souza, 2019-07-24 16:59:20