Hi All,
Ok - my head hurts (sadly not through overindulgence - although I'm considering it as a better option than trying to get my brain around this conundrum) - I'm sure this is simple and I'm probably just getting lost in the logic.... So I call upon your collective genius to remind me how age has destroyed my brain, so much that it can comprehend the weather in greater detail than being able to get the desired result from an equation![Smile :) :)](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
So, in the table below I need to bring back the resulting farm that produced the largest amount of fruit in a given month (I can bring back the quantity - as the MAX function happily works this out). The options for which fruit and month are driven by a drop down menu, with the resulting farm and yield formulaically calculated from the data array.
Really appreciate any help!
Range: A1:F16
Fruit to lookup: I2 (drop down list, but for sake of this example - just the single cell)
Month to examine: I3 (drop down list, but for sake of this example - just the single cell)
Resulting Farm: I5
Yield: I6
<tbody>
</tbody>
Ok - my head hurts (sadly not through overindulgence - although I'm considering it as a better option than trying to get my brain around this conundrum) - I'm sure this is simple and I'm probably just getting lost in the logic.... So I call upon your collective genius to remind me how age has destroyed my brain, so much that it can comprehend the weather in greater detail than being able to get the desired result from an equation
So, in the table below I need to bring back the resulting farm that produced the largest amount of fruit in a given month (I can bring back the quantity - as the MAX function happily works this out). The options for which fruit and month are driven by a drop down menu, with the resulting farm and yield formulaically calculated from the data array.
Really appreciate any help!
Range: A1:F16
Fruit to lookup: I2 (drop down list, but for sake of this example - just the single cell)
Month to examine: I3 (drop down list, but for sake of this example - just the single cell)
Resulting Farm: I5
Yield: I6
A | B | C | D | E | F | G | H | I | |
1 | Fruit | Farm | Jan Yield | Feb Yield | Mar Yield | Apr Yield | |||
2 | Apples | Red | 10 | 20 | 30 | 40 | What Fruit? | Apples | |
3 | Apples | Blue | 20 | 30 | 20 | 50 | What Month? | Jan | |
4 | Apples | Green | 30 | 10 | 10 | 60 | |||
5 | Pears | Red | 10 | 20 | 30 | 40 | Best Farm? | Formula? | |
6 | Pears | Blue | 20 | 30 | 20 | 50 | Qty Yielded? | Formula? | |
7 | Pears | Green | 30 | 10 | 10 | 60 | |||
8 | Kiwi | Red | 10 | 20 | 30 | 40 | |||
9 | Kiwi | Blue | 20 | 30 | 20 | 50 | |||
10 | Kiwi | Green | 30 | 10 | 10 | 60 | |||
11 | Oranges | Red | 10 | 20 | 30 | 40 | |||
12 | Oranges | Blue | 20 | 30 | 20 | 50 | |||
13 | Oranges | Green | 30 | 10 | 10 | 60 | |||
14 | Tomatoes | Red | 10 | 20 | 30 | 40 | |||
15 | Tomatoes | Blue | 20 | 30 | 20 | 50 | |||
16 | Tomatoes | Green | 30 | 10 | 10 | 60 |
<tbody>
</tbody>