FORMULAS for lowest cost on an item

I am creating a price sheet for our company. I have price lists from our 3 distributors. I want to add our cost from each distributor in separate columns for each item. a retail price in a fo...