![]() |
|
|
Thread Tools | Display Modes |
#4
|
||||
|
||||
![]()
I was afraid you were going to follow up with that question
![]() Ok first insert a column for volume in column E and enter volumn formula: Code:
=Product(B2:D2) Then try this Array* formula: Assuming your inputs have shifted over a column, now in K2: Code:
=INDEX($A$2:$A$8,MATCH(1,($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2)*($E$2:$E$8=(MIN(IF(($B$2:$B$8>=G2)*($C$2:$C$8>=H2)*($D$2:$D$8>=I2),$E$2:$E$8)))),0)) *This formula must be confirmed with CTRL+SHIFT+ENTER not just ENTER before copying down. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
apophis | Word | 8 | 10-12-2015 01:48 AM |
![]() |
Mac265 | Word | 4 | 01-23-2015 11:27 AM |
Pick up Style tool (eye dropper) | ParreDL | Word | 7 | 03-20-2012 06:40 AM |
Font size in dialog boxes | nannycheryl | Word | 0 | 07-10-2010 09:26 AM |
![]() |
jmarin | Excel | 1 | 12-05-2008 02:31 AM |