Forum Discussion
bhowell
Sep 28, 2020Copper Contributor
Index, match and max function with specific criteria
Hello, I am using the following formula to index and match a row with the highest value. =INDEX(A5:A35,MATCH(MAX(G5:G35),G5:G35,0)) I would like to add an IF statement with a specific criter...
Subodh_Tiwari_sktneer
Sep 28, 2020Silver Contributor
You may try something like this...
=INDEX(A5:A35,MATCH(MAX(INDEX((B5:B35="ATV / SxS")*G5:G35,)),G5:G35,0))