PDA

View Full Version : Extracting data from a table



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,