Does anyone have any suggestions on following statement?
=INDEX(A3:A26,MATCH(MIN(AI3:AI26),K3:K26,0)), which work OK
but if the lookup arrary is a table of matrix C3:Q26,
=INDEX(A3:A26,MATCH(MIN(AI3:AI26),C3:Q26,0)), then it returns #N/A,
The task is to look for the minimum value under AI3:AI26 matching with a
table of matrix under C3:Q26, and then return the value under A3:A26 on the
same row.
it seems to me that the match function cannot work with a table of matrix.
Does anyone have any suggestions on how to match a value from a table of
matrix?
Thank you for any suggestions
Eric