Hi guys, I used this formula before and that I had to make some changes, it stopped functioning the way it supposed to
in I7, this is the formula
The formula is supposed to index "X' and find the name of the product that has highest score (row15) and smallest LD50 (row5)
in I7, this is the formula
Code:
IF(A7="","",INDEX(C$1:H$1,MATCH(MAX(IF(C7:H7<>"",C$15:H$15-C$5:H$5/1000)),IF(C7:H7<>"",C$15:H$15-C$5:H$5/1000),0)))