Spreadsheet: 851239d1701454149-index-match-multiple-column-creteria-confusion-test
Sheet: Sheet1

Deparment | Three
Course | Pears |  | Department | Course | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Month | May |  | One | Apples | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
RESULT | 16.6 |  | One | Pears | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  |  | One | Juice | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44 | 44
what formula delivers the result 16.6 and changes when the cells A1, A2 and A4 are changed? |  |  | One | Grapes | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43 | 43
 |  |  | One | Oranges | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 32
 |  |  | Two | Apples | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4 | 33.4
 |  |  | Two | Pears | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6 | 30.6
 |  |  | Two | Juice | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8 | 27.8
 |  |  | Two | Grapes | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  | Two | Oranges | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2 | 22.2
 |  |  | Three | Apples | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4 | 19.4
 |  |  | Three | Pears | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6 | 16.6
 |  |  | Three | Juice | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8 | 13.8
 |  |  | Three | Grapes | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
 |  |  | Three | Oranges | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2 | 8.2
 |  |  | Four | Apples | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4 | 5.4
 |  |  | Four | Pears | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6 | 2.6
 |  |  | Four | Juice | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003 | -0.200000000000003
 |  |  | Four | Grapes | -3 | -3 | -3 | -3 | -3 | -3 | -3 | -3 | -3 | -3 | -3 | -3
 |  |  | Four | Oranges | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8 | -5.8
 |  |  | Five | Apples | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6 | -8.6
 |  |  | Five | Pears | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4 | -11.4
 |  |  | Five | Juice | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2 | -14.2
 |  |  | Five | Grapes | -17 | -17 | -17 | -17 | -17 | -17 | -17 | -17 | -17 | -17 | -17 | -17
 |  |  | Five | Oranges | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8 | -19.8
 |  |  | Six | Apples | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6 | -22.6
 |  |  | Six | Pears | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4 | -25.4
 |  |  | Six | Juice | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2 | -28.2
 |  |  | Six | Grapes | -31 | -31 | -31 | -31 | -31 | -31 | -31 | -31 | -31 | -31 | -31 | -31
 |  |  | Six | Oranges | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8 | -33.8