0
How to return a company based on a value, even if the Matrix has several duplicates. You can return the first found.
1 answer
1
I solved using 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)));"")}
Browser other questions tagged excel procv
You are not signed in. Login or sign up in order to post.
=PROCVlooks only in the first column, so it is not recommended to search in a 2D matrix.– danieltakeshi