Match and Display Text

[awickens]

[TABLE="width: 456"]
<colgroup><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD]Eng1[/TD]
[TD]Eng2[/TD]
[TD]Eng3[/TD]
[TD]Lowest Miles[/TD]
[TD] Eng[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]39[/TD]
[TD]52[/TD]
[TD="align: center"]39[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



I want to match the 'lowest miles' number to the three ENG numbers. When matched, I want to display the ENG1/2/3 under ENG

 

[Fluff]

Hi & welcome to MrExcel.
How about

Book1
	A	B	C	D	E
1	Eng1	Eng2	Eng3	Lowest Miles	Eng
2	40	39	52	39	Eng2
Database

Cell Formulas
Range	Formula
E2	=INDEX($A$1:$C$1,MATCH(D2,A2:C2,0))