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