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[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Vauxhall[/TD]
[TD]Ford[/TD]
[TD]Hall[/TD]
[/TR]
[TR]
[TD]Gearbox[/TD]
[TD]500[/TD]
[TD]450[/TD]
[TD]600[/TD]
[/TR]
[TR]
[TD]Engine[/TD]
[TD]1000[/TD]
[TD]1200[/TD]
[TD]800[/TD]
[/TR]
[TR]
[TD]Steering[/TD]
[TD]250[/TD]
[TD]350[/TD]
[TD]275[/TD]
[/TR]
[TR]
[TD]Ignition[/TD]
[TD]50[/TD]
[TD]70[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]CYHead[/TD]
[TD]300[/TD]
[TD]290[/TD]
[TD]310[/TD]
[/TR]
</tbody>[/TABLE]

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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Maker[/TD]
[TD]Spare[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Vauxhall
[/TD]
[TD]Ignition[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]VW[/TD]
[TD]GearBox[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[TD]Engine[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]VW[/TD]
[TD]Steering[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[TD]Ignition[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[TD]CYHead[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Vauxhall[/TD]
[TD]GearBox[/TD]
[TD]?[/TD]
[/TR]
[TR]
[TD]Ford[/TD]
[TD]Engine[/TD]
[TD]?[/TD]
[/TR]
</tbody>[/TABLE]
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