Formula to Indicate Alphabetical Data Connected to Numeric Data

[tcluer]

I have a question about using conditional formatting in excel (2010); I made a table with the following columns: “Supplier Name” “Supplier Lead Time” “Internal Lead Time” “Total Lead Time” (If you need to see the table to visualize, please email me at [email protected]). I made two different scenarios to show different supplier lead times and different internal lead times, and used the minimum function in the "Total Lead Time" column to find the smallest total lead time to help select the best supplier.
The last thing I would want to do with this set of data, which I am consequently asking for help with, is plug in a formula that would somehow indicate which supplier corresponds to the shortest total lead time (which supplier has the smallest supplier lead time). I’d like to be able to use a formula that enters the name of the supplier in a designated cell, which I could indicate as the “Preferred Supplier” cell. If this is not possible perhaps there is a way to highlight the supplier’s name with conditional formatting? Any help achieving my goal with either method would be very appreciated.

Thank you,
Tim

[perimidt]

Could there be two suppliers with the same lead-time?
If not you might want to check out INDEX and MACTH, maybe something like this if your suppliers are from A2:A5 and leadtimes from D2:D5:

INDEX(A2:A5,MATCH(MIN(D2:D5),D2:D5,0))

[tcluer]

Thank you, I will try it out post results asap.

Edit: Might be operator error but excel is telling me there are two few arguments. I have to switch tasks for the time being but will attempt again later tonight.

Thanks,
Tim

Edit: Worked! Thank you