Something like

=MIN("Bayer Inc:Zeus plc'!A1)

where the two sheet names are the first and last, and A1 is the cell to test

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bryan" wrote in message
...
I have a spreadsheet with 7 workbooks in it. Each spreadsheet has a
company
name and a price for a product.

On a master sheet I wrote a Min function that will choose the least cost
of
each product and display it.

I would like to know which company had the least cost. In other words I
would like to know where the least cost price was pulled from.

thanks.