Look up on single row set of data

[jusho]

Hi, I need help with my set of data. I recently download a set of data and unfortunately, the data is in a single row per entry. I need to look up the data.

Example the data is

New York	Apple	100​	Orange	75​	Grape	50​
Tokyo	Orange	40​	Apple	30​	Grape	65​
Jakarta	Grape	10​	Apple	40​	Orange	75​

I neet to look up to fill the data like this

	Apple	Orange	Grape
New York
Tokyo
Jakarta

Is there any formula to achieve this, I cant use VBA on this file.

Thanks a lot

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	New York	Apple	100	Orange	75	Grape	50
2	Tokyo	Orange	40	Apple	30	Grape	65
3	Jakarta	Grape	10	Apple	40	Orange	75
4
5
6
7
8		Apple	Orange	Grape
9	New York	100	75	50
10	Tokyo	30	40	65
11	Jakarta	40	75	10
12
Main

Cell Formulas
Range	Formula
B9:D11	B9	=SUMPRODUCT(($A$1:$A$3=$A9)*($B$1:$F$3=B$8),($C$1:$G$3))

 

[jusho]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	New York	Apple	100	Orange	75	Grape	50
2	Tokyo	Orange	40	Apple	30	Grape	65
3	Jakarta	Grape	10	Apple	40	Orange	75
4
5
6
7
8		Apple	Orange	Grape
9	New York	100	75	50
10	Tokyo	30	40	65
11	Jakarta	40	75	10
12
Main

Cell Formulas
Range	Formula
B9:D11	B9	=SUMPRODUCT(($A$1:$A$3=$A9)*($B$1:$F$3=B$8),($C$1:$G$3))

Hi.. i have already tried your suggestion but the outcome is 0. I thinks its already same with yours.

 

[Fluff]

That suggests that your "numbers" are actually text. You will need to convert them to real numbers.