Hi, im looking for the right formula to give me the following outcome .


If Cell contains the word "Survey" and the Cell next to it is not blank, then I want the outcome as "Confirmed", or "Unconfirmed"

Can you help please?

Thanks

Nath'