Do you need the lowest price, or the identity of the lowest cost provider?

lowest price (assumes you name each vendors' price list range, and that each
range is 2 columns - item # & price):

=Min(lookup(item#, range1,2,0),lookup(item#, range2,2,0),lookup(item#,
range3,2,0))


"dphi201" wrote:

I am making a master pricing worksheet catalog. I am purchasing the same
products from mulitple vendors, all use the same product code as well. I have
set up 3 different vendors to compare prices on items. How do i put a formula
together on my master worksheet to scan these other 3 worksheets that are
identical to where i can have my master worksheet return the lowest price? So
if I type in product #1234 in the master sheet it will look at Sheet 1:3 and
return the lowest priced product?