Order Issue? Index Table Chooses The First Option When Two Rows Have Same Result

I asked a question about LARGE() and pulling data from a table. It was answered here:
http://www.excelforum.com/excel-form...said-list.html

The formula works great. There's something I noticed while replicating, though. If I generate a list where multiple results are the same, the names get mixed.

For instance, in the following table:

Make	Model	Top Speed
Chrysler	Coupe	120
Dodge	Pick-up	130
Ford	Sedan	123
Chevy	4-door	150
Pontiac	4-door	142
Dodge	Sedan	130
Ford	Electric	133
Chevy	Convertible	153
Pontiac	4x4	142
BMW	Sedan	160
Audi	Supercar	226
BMW	Supercar	160

... and using the formula provided:
=INDEX(B$3:B$14,MATCH(LARGE(IF(($D$3:$D$14="4-door")+($D$3:$D$14="Sedan")+($D$3:$D$14="Electric"),$F$3:$F$14),ROWS($2:2)),$F$3:$F$14,0))

... the resulting table includes a Dodge pick-up truck:

BMW	Sedan	160
Chevy	4-door	150
Pontiac	4-door	142
Ford	Electric	133
Dodge	Pick-up	130

The issue is that the formula recognizes the Dodge sedan doing 130 mph. However, the Dodge pick-up has the same speed. The formula errantly prints the pick-up rather than sedan.

Is there an ORDER modifier I need in this?

Originally Posted by Tony Valko

Enter this formula in H2:

=IFERROR(LARGE(IF(ISNUMBER(MATCH(B$2:B$13,E$2:E$4,0)),C$2:C$13),ROWS(H$2:H2)),"")

Enter this formula in G2:

=IF(H2="","",INDEX(B:B,SMALL(IF(ISNUMBER(MATCH(B$2:B$13,E$2:E$4,0))*(C$2:C$13=H2),ROW(B$2:B$13)),COUNTIF(H$2:H2,H2))))

Enter this formula in F2:

=IF(H2="","",INDEX(A:A,SMALL(IF(ISNUMBER(MATCH(B$2:B$13,E$2:E$4,0))*(C$2:C$13=H2),ROW(B$2:B$13)),COUNTIF(H$2:H2,H2))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Select F2:H2 and copy down until you get a row full of blanks.

At first I thought that indexing a column wouldn't work. This is the first of many tables replicated downwards, so imagine 5, 20, or more of these. However, the information is the same in each column, so it could.

I was able to make it work in a simple "2-story" stack. I'll look at what FlameRetired as to say before declaring this solved, though. Your solution can work, so I appreciate the time and effort, thank you.

Originally Posted by FlameRetired

Slightly different approach.

In H2 array-enter this formula and fill down.

Formula:

Please Login or Register  to view this content.

Then in E2 array-enter this fill down and across to column G.

Formula:

Please Login or Register  to view this content.

Row\Col	A	B	C	D	E	F	G	H
1	Make	Model	Top Speed					helper
2	Chrysler	Coupe	120		BMW	Sedan	160	160
3	Dodge	4-door	130		Chevy	4-door	150	150
4	Ford	Sedan	123		Pontiac	4-door	142	142
5	Chevy	4-door	150		Ford	Electric	133	133
6	Pontiac	4-door	142		Dodge	Sedan	130	130
7	Dodge	Sedan	130		Dodge	4-door	130	130
8	Ford	Electric	133		Ford	Sedan	123	123
9	Chevy	Convertible	153
10	Pontiac	4x4	142
11	Dodge	Pick-up	130
12	BMW	Sedan	160
13	Audi	Supercar	226
14	BMW	Supercar	160

Is there a reason I need the helper column and just can't use it? I could copy the second formula over twice/two columns and not worry about the duplicate value, right? Or am I missing something?

FlameRetired, thank you immensely. Tony Valko, your solution, while viable, is tad more complex. Both work well and are robust.

Thank you both for the time and knowledge.