Nicolaf
07-24-2015, 01:07 AM
Hi,
I have data in a table format in Sheet2.
In Sheet2
B
C
D
E
F
1
January
Rome
Milan
Florence
2
apples
10
11
12
3
pears
7
2
4
4
melons
1
2
3
5
6
7
8
February
Rome
Milan
Florence
9
apples
17
10
4
10
pears
3
6
5
11
melons
4
1
6
The months are in column B the fruit names in column C and the cities in columns F, G and H.
I would like a formula which we use in Sheet1 that gives me the number of pears in Milan for the month of February.
The formula should follow this logic:
1. Look for month February (from column B Sheet2)
2. Go to Milan (in that row)
3. Give me number of pears related to Milan (ie.6)
What is best formula to use?
Thanks,
I have data in a table format in Sheet2.
In Sheet2
B
C
D
E
F
1
January
Rome
Milan
Florence
2
apples
10
11
12
3
pears
7
2
4
4
melons
1
2
3
5
6
7
8
February
Rome
Milan
Florence
9
apples
17
10
4
10
pears
3
6
5
11
melons
4
1
6
The months are in column B the fruit names in column C and the cities in columns F, G and H.
I would like a formula which we use in Sheet1 that gives me the number of pears in Milan for the month of February.
The formula should follow this logic:
1. Look for month February (from column B Sheet2)
2. Go to Milan (in that row)
3. Give me number of pears related to Milan (ie.6)
What is best formula to use?
Thanks,