djungstCopper ContributorMay 09, 2021SolvedReturn 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". Return MIN based on Criteria.xlsx9 KBHansVogelaarMay 09, 2021djungst Try =INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))
HansVogelaarMay 09, 2021djungst Try =INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))
HansVogelaarMay 09, 2021djungst Try =INDEX(A1:A5,MATCH(1,INDEX((F1:F5=MINIFS(F1:F5,G1:G5,"RS"))*(G1:G5="RS"),,),0))
SergeiBaklanDiamond ContributorMay 10, 2021djungst As variant =XLOOKUP("RS",SORTBY(G1:G5,F1:F5),SORTBY(A1:A5,F1:F5))
