More info required. Lay out the data.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Johnson" wrote in message
...
I need to be able to find the cheapest out of a range of data and then
specify which is the cheapest as a name (text).

I also need to be able to use an if statement over 2 sheets?

Cheers,

M.Johnson