How do I lookup a condition and then specify a result?

[necht_angel]

Hi there,

I have been struggling with this formula for ages, and have finally given in to ask for help

Basically I have a formula on sheet 1 in cells S11:S227 which is working nicely. Now what I want to do, is if the 'ERROR VARIATION NOT FULLY INVOICED' message that I have specified appears, I would like on sheet 2 for another message to appear saying 'ATTENTION VARIATIONS HAVE NOT BEEN INVOICED'.

I have been playing with SEARCH, IF and LOOKUP, but I am stuck.

Any assistance would be very much appreciated.

Thank you

Kate

[Tony Valko]

Something like this:

=IF(COUNTIF(Sheet1!S11:S22,"ERROR NOT FULLY INVOICED"),"ATTENTION VARIATIONS HAVE NOT BEEN INVOICED","")

[benishiryo]

hi Kate, not sure if i understand correctly. in sheet2:
=IF(COUNTIF(Sheet1!S11:S22,"ERROR NOT FULLY INVOICED"),"ATTENTION VARIATIONS HAVE NOT BEEN INVOICED","")

[necht_angel]

Thanks so much guys, that was really helpful. I perhaps could have saved myself hours by asking sooner

Kate

[Tony Valko]

You're welcome. We appreciate the feedback!