How to populate Name based on lowest bid?

[xlmaniac]

Dear All,
I do have a small Data Set as follows.
I would like to populate the name of the lowest bidder based on the lowest quote.
Could somebody help me with the formulae across H3:H5 pls?
Regards
Sheet1

*	A	B	C	D	E	F	G	H	I
1	*	1st Quotation	2nd Quotation	3rd Quotation	Final
2	Particulars	Party Name	Quotation	Party Name	Quotation	Party Name	Quotation	Party Name	Quotation
3	Asset1	A	100	D	150	G	170	A	100
4	Asset2	B	200	E	100	H	180	E	100
5	Asset3	C	300	F	150	I	210	F	150

<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 69px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"><col style="width: 76px;"><col style="width: 63px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula I3 =MIN(G3,E3,C3) I4 =MIN(G4,E4,C4) I5 =MIN(G5,E5,C5) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

 

[bbott]

Try this in H3 and copy down.

=INDEX(B3:G3,1,MATCH(I3,B3:G3,0)-1)

or, if you don't want to use the reference to the MIN in column I:

=INDEX(B3:G3,1,MATCH(MIN(C3,E3,G3),B3:G3,0)-1)

 

[xlmaniac]

Thank you so much bbott for all your support...
Really appreciate the same..
You have saved hours of my working on this file..
Thanks again

 

[bbott]

Thank you so much bbott for all your support...
Really appreciate the same..
You have saved hours of my working on this file..
Thanks again

You're welcome.