Auto Populate on different sheet from lowest total bidder - Dollars and Name.

I am trying to auto-populate a different sheet from numbers that I enter manually and they calcuclate the total. From this lowest total we determine who the winner is of this bid. I'm just not clear on the "MIN" and "MATCH" functions to make this work. I have attached an example file that better shows my intent. I have also added some notes in this file that may assist you in showing my intent.

Thank you in advance for your help.

Hi
Do you have to include the reimbursable values in the same column as your bid totals? It introduces a range of zero values that means you can't do a simple formula based on the minimum in range H4:H15. If you remove these, you can use the match formula:

Please Login or Register  to view this content.

To determine the row containing the lowest aggregate bid in column H, then use this as an offset to return a formula linked to the row you want in your cont# sheet, eg:

In cell B7:

Please Login or Register  to view this content.

In cell C7:

Please Login or Register  to view this content.

NickyC,

I removed the reimbursables and reorganized the spreadsheet a little and that worked perfectly. Thank you! Now i have another question/issue. What happens when one of the engineers does not submit a bid? All the cells end up being $0 in that row which per the calculations they end up the lowest bidder. I need to track when one engineer doesn't submit a bid but is there a way to remove that $0 possibility and the calculation takes the next lowest bidder?

I have attached the modified spreadsheet showing my example.

Thank you.

Hi
one way would be to change the formula on your "consultant" sheet so it returns a string not a number if the total is zero, e.g. in cell K4

=IF(SUM(D4:G4)+SUM(H5:J5)=0,"no bid",SUM(D4:G4)+SUM(H5:J5))

Thank you NickyC. Problem solved. You were great help. Thanks!