EDIT: I wrote MAX in the Heading incorrectly although the syntax should be the same I guess...
Hello,
I want to know which of the Y's that give the minimum value for the product between table 1 and 2. I.e. I want cell B2 to give me Y1, B3 to give me Y2, B4 to give me Y1 and B5 to give me Y3. My last try for a formula was.![]()
=INDEX($H$1:$J$1;1;MATCH(MIN(IF($G$2:$G$5=$A2;$H$2:$J$5)*C2:E2);IF($G$2:$G$5=$A2;$H$2:$J$5)*C2:E2;0))
Please help!
PrintScreen till ExcelForum.JPG
Bookmarks