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?