Bryan,

Look up Excels MIN function in the online help. An example of the formula
to find the minimum values cell A1 of Sheet1, Sheet2, and Sheet3 would be:

=MIN(A1,Sheet2!A1,Sheet3!A1)

----
Regards,
John Mansfield
http://www.pdbook.com

"Bryan" wrote:

I have an excel spreadsheet that has 5 or so Workbooks in it. On each of
these workbooks I have a company name and a price for a product.

I would like to write a function on a Master page to compair each price on
each workbook and then on the master page display the company name of the
company that had the lowest price.

thanks