The formula needs to find the value of the width of 34.25 from rows A-5 thru B-16, and the value of the height of 31.2 from columns D-2thru I-3 and display the value in the cell that meets the result.Which width to consider from col A or from Colum B? to get desired result?
and same question for height.
Fluff.xlsm | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | |||||||||||
2 | 12 | 14 | 16 | 18 | 20 | 22 | |||||
3 | |||||||||||
4 | |||||||||||
5 | 17.5 | 7-1 | 7-1 | 7-1 | 7-2 | 7-2 | 7-2 | ||||
6 | 19.5 | 8-1 | 8-1 | 8-2 | 8-2 | 8-2 | 8-2 | ||||
7 | 21.5 | 9-1 | 9-1 | 9-2 | 9-2 | 9-2 | 9-3 | ||||
8 | 23.5 | 10-1 | 10-2 | 10-2 | 10-2 | 10-2 | 10-2 | ||||
9 | 25.5 | ||||||||||
10 | 27.5 | ||||||||||
11 | 29.5 | ||||||||||
12 | 31.5 | ||||||||||
13 | 33.5 | ||||||||||
14 | 35.5 | ||||||||||
15 | 37.5 | ||||||||||
16 | 39.5 | ||||||||||
17 | |||||||||||
18 | |||||||||||
19 | 22.43 | ||||||||||
20 | 21.5 | 9-2 | |||||||||
21 | |||||||||||
Main |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C20 | C20 | =INDEX(D5:I16,MATCH(B19,A5:A16,1),MATCH(B20,D2:I2,1)) |