Forum Discussion

djungst's avatar
djungst
Copper Contributor
May 09, 2021
Solved

Return a value based on MIN

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".
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 09, 2021

    djungst 

    Try

     

    =INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))

HansVogelaar's avatar
HansVogelaar
MVP
May 09, 2021

djungst 

Try

 

=INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))

djungst's avatar
djungst
Copper Contributor
May 09, 2021
Hans, this worked perfectly. Thanks for your help.

Resources