Hello,
I hope someone will be able to help me,

How do I create a formula that will check a certain cell for text
=IF(B25="SAT"

and then, If that is True search another worksheet for any values less than 1
=IF(B25="SAT",IF('Sheet2'!F5:F300<1,"NAME",""))

Then, depening on whether it finds anything less than one I REALLY want it
to look at a different column in Sheet2 and produce the NAME for any that are
less than 1 in the previous result.

If anyone could at least tell me if it is possible to get excel to display
the text from a different column that would be great help!

Thanks
Jane