finding the least cost number from a group of reference numbers

Hello, I am looking to  have excel return the results of the least cost option from reference number 1, then 2 then 3 etc..  We are trying to get optimal results using multiple vendors.       Pleas...