Formula to find a certain word in the last entry

[danbates]

Hi,

Please can someone help me?

I would like a formula that looks for the word "Azera" in the last entry in column C.

If it finds "Azera" then it returns the word "Azera" in the cell I put the formula.

If it cannot find "Azera" then it returns "No" and any help would be appreciated.

I hope this makes sense.

Thanks

Dan

 

[Eric W]

Perhaps

=IF(ISERROR(SEARCH("azera",LOOKUP("zzzzzzz",C:C))),"No","Azera")

 

[danbates]

Perfect, thank you.

 

[Eric W]

Glad to help.