Vlookup help

[Noxqss38242]

SRT Tracker.xlsm
	B	C	D
114	4	1.2	ACCESS
115	9	7.6	AERODY
116	10	18.5	APU-EL
117	17	24.2	BODY
118	20	25	BRKTRA
119	18	22	BRKTRL
120	17	26.2	CAB
121	5	9.5	CHGSYS
122	11	11.3	COOLSY
123	24	45	CRNKSY
124	3	8.9	DRVLNE
125	7	4.5	ELACCS
126	15	15.6	ENGINE
127	10	8.8	EXHSYS
128	24	16.6	FRAME
129	2	2	FUELSY
130	3	3.4	GAUGE
131	3	7.5	HEATER
132	4	4.3	HVAC
133	4	2.9	INFLSY
134	2	1.6	INTAKE
System

Cell Formulas
Range	Formula
B114:B134	B114	=COUNTA(B12:AS12)
C114:C134	C114	=SUM(B12:AS12)
D114:D134	D114	=IF(A12="","",A12)

I'm wanting to use vlookup but if that won't work, then I'm not opposed to using a different method.
What I'm wanting is to pull large 1, 2, 3, 4, 5 for column B
Then I was trying to use vlookup to pull which system....access, aerody, apu-el, etc...
But when I do that, 24 is repeated but vlookup stops when if sees the first match and returns "2" CRNKSY when the next 24 should be FRAME.
I'm assuming as my numbers change it will also be a problem for column C when using the same method.

Any suggestions?

 

[Eric W]

Try:

Book1
	B	C	D	E	F	G	H
113					Large	Value	Name
114	4	1.2	ACCESS		1	24	CRNKSY
115	9	7.6	AERODY		2	24	FRAME
116	10	18.5	APU-EL		3	20	BRKTRA
117	17	24.2	BODY		4	18	BRKTRL
118	20	25	BRKTRA		5	17	BODY
119	18	22	BRKTRL
120	17	26.2	CAB
121	5	9.5	CHGSYS
122	11	11.3	COOLSY
123	24	45	CRNKSY
124	3	8.9	DRVLNE
125	7	4.5	ELACCS
126	15	15.6	ENGINE
127	10	8.8	EXHSYS
128	24	16.6	FRAME
129	2	2	FUELSY
130	3	3.4	GAUGE
131	3	7.5	HEATER
132	4	4.3	HVAC
133	4	2.9	INFLSY
134	2	1.6	INTAKE
Sheet4

Cell Formulas
Range	Formula
G114:G118	G114	=LARGE($B$114:$B$134,F114)
H114:H118	H114	=INDEX(D:D,AGGREGATE(15,6,ROW($B$114:$B$134)/($B$114:$B$134=G114),COUNTIF($G$114:$G114,G114)))

 

[Fluff]

How about

+Fluff v2.xlsm
	B	C	D	E	F	G	H
114	4	1.2	ACCESS		24	45	CRNKSY
115	9	7.6	AERODY		24	16.6	FRAME
116	10	18.5	APU-EL		20	25	BRKTRA
117	17	24.2	BODY		18	22	BRKTRL
118	20	25	BRKTRA		17	24.2	BODY
119	18	22	BRKTRL
120	17	26.2	CAB
121	5	9.5	CHGSYS
122	11	11.3	COOLSY
123	24	45	CRNKSY
124	3	8.9	DRVLNE
125	7	4.5	ELACCS
126	15	15.6	ENGINE
127	10	8.8	EXHSYS
128	24	16.6	FRAME
129	2	2	FUELSY
130	3	3.4	GAUGE
131	3	7.5	HEATER
132	4	4.3	HVAC
133	4	2.9	INFLSY
134	2	1.6	INTAKE
Main

Cell Formulas
Range	Formula
F114:F118	F114	=LARGE($B$114:$B$134,ROWS(F$114:F114))
G114:H118	G114	=INDEX(C$114:C$134,AGGREGATE(15,6,(ROW($B$114:$B$134)-ROW($B$114)+1)/($B$114:$B$134=$F114),COUNTIFS($F$114:$F114,$F114)))

 

[Noxqss38242]

I made it work with the formulas provided. Thanks all!

 

[Eric W]

Glad we could help! Thanks for the feedback.