Trying to fetch data from HLOOKUP

[ANAND KUMAR]

Hi Experts,

I found myself in a situation, I Have two Sheets Data in Horizontally and want fetch some details from them vertically as following: Sheet 1

	Vauxhall	Ford	Hall
Gearbox	500	450	600
Engine	1000	1200	800
Steering	250	350	275
Ignition	50	70	45
CYHead	300	290	310

<tbody>
</tbody>

and I want fetch blank details as per below (Sheet 2)

Maker	Spare	Cost
Vauxhall	Ignition	?
VW	GearBox	?
Ford	Engine	?
VW	Steering	?
Ford	Ignition	?
Ford	CYHead	?
Vauxhall	GearBox	?
Ford	Engine	?

<tbody>
</tbody>

Your request would be appreciated. Thanks in Advance!

 

[FormR]

Hi, welcome to the forum! See if you can adapt this to your set-up.

Sheet2

Excel 2013
	A	B	C
1	Maker	Spare	Cost
2	Vauxhall	Ignition	50
3	VW	GearBox	5
4	Ford	Engine	1200
5	VW	Steering	5
6	Ford	Ignition	70
7	Ford	CYHead	290
8	Vauxhall	GearBox	500
9	Ford	Engine	1200
Sheet2

Cell Formulas
Range	Formula
C2	=INDEX(Sheet1!$B$2:$Z$1000,MATCH(B2,Sheet1!$A$2:$A$1000,0),MATCH(A2,Sheet1!$B$1:$Z$1,0))

Sheet1

Excel 2013
	A	B	C	D	E
1		Vauxhall	Ford	Hall	VW
2	Gearbox	500	450	600	5
3	Engine	1000	1200	800	1
4	Steering	250	350	275	5
5	Ignition	50	70	45	6
6	CYHead	300	290	310	4
Sheet1

 

[ANAND KUMAR]

Got It Thank a lot...............

 

[FormR]

Great, good to hear