How to populate Name based on lowest bid?

xlmaniac

Well-known Member
Joined
Jul 2, 2009
Messages
527
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
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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)
 
Upvote 0
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:):)
 
Upvote 0

Forum statistics

Threads
1,214,720
Messages
6,121,121
Members
449,013
Latest member
JerrExcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top