Lets assume you type the product code in A1
And that the three sheets have product codes in A1:A1000 and prices in
B1:B1000
And these are called Sheet1, Sheet2, Sheet3
You want the price returned to B1
=MIN(VLOOKUP(A1,Sheet1!A1:B10-00,2,FALSE),VLOOKUP(A1,Sheet2!A1:B10-00,2,FALSE),VLOOKUP(A1,Sheet3!A1:B10-00,2,FALSE)

Now tell us if all three sheets have every code? If not then we must add
some error checking along the lines of this untested code
=MIN(IF(ISNA(VLOOKUP(A1,Sheet1!A1:B10-00,2,FALSE)),1E6,VLOOKUP(A1,Sheet1!A1:B10-00,2,FALSE)),IF(ISNA(VLOOKUP(A1,Sheet2!A1:B10-00,2,FALSE)),1E6,VLOOKUP(A1,Sheet2!A1:B10-00,2,FALSE)),IF(ISNA(VLOOKUP(A1,Sheet3!A1:B10-00,2,FALSE)),1E6,VLOOKUP(A1,Sheet3!A1:B10-00,2,FALSE)))
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"dphi201" wrote in message
...
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?