May 09 2021 11:09 AM
I want to return a value located on column "A" that corresponds to a minimum value located in column "F" if it meets a criteria based on information contained in column "G".
May 09 2021 11:54 AM
SolutionMay 09 2021 01:14 PM
May 10 2021 01:55 AM
May 09 2021 11:54 AM
SolutionTry
=INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))