How to populate Name based on lowest bid?

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
500
Office Version
  1. 2010
Platform
  1. Windows
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

*ABCDEFGHI
1*1st Quotation2nd Quotation3rd QuotationFinal
2ParticularsParty NameQuotationParty NameQuotationParty NameQuotationParty NameQuotation
3Asset1A100D150G170A100
4Asset2B200E100H180E100
5Asset3C300F150I210F 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
CellFormula
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

bbott

Well-known Member
Joined
Feb 5, 2010
Messages
2,350
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

Well-known Member
Joined
Jul 2, 2009
Messages
500
Office Version
  1. 2010
Platform
  1. Windows
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:):)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,037
Messages
5,526,402
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top