Hello,
I am trying to write a formula that will work with the following:
If we say that 'product' is cell A1
| Product |
Client |
Jul |
Aug |
Sept |
Oct |
Nov |
Dec |
| ORANGE |
JOHN |
10.000 |
20.000 |
30.000 |
40.000 |
30.000 |
20.000 |
| |
|
10.000 |
20.000 |
30.000 |
40.000 |
30.000 |
20.000 |
| LEMON |
PETER |
11.025 |
25.315 |
56.215 |
33.330 |
24.521 |
26.631 |
| |
|
11.025 |
25.315 |
56.215 |
33.330 |
24.521 |
26.631 |
| LIME |
PAUL |
34.000 |
34.525 |
62.542 |
36.221 |
32.525 |
21.215 |
| ORANGE |
PAUL |
10.000 |
20.000 |
30.000 |
40.000 |
30.000 |
20.000 |
| |
|
44.000 |
54.525 |
92.542 |
76.221 |
62.525 |
41.215 |
I have another workbook:
If we say 'client' is cell A1
| Client |
paul |
product |
lime |
|
|
| |
|
|
|
|
|
| |
jul |
aug |
sept |
oct |
nov |
| |
|
|
|
|
|
I need to match the first table with the second to show the value for the month, for paul and lime.
so in this instance, in cell B4, i would like to insert the formula to show, that if A2= paul and A4 = lime show the value that corresponds with B3 (jul) from the other table = 34000.
apologies about the terrible explanation.
