Using wildcard (*.*) in an excel formula

[suet]

Hi

I hope someone can help me on this.

I have a spreadsheet similar to the following

Room Location Unit Room Name Surveyor Needed
Upstairs 2 Bathroom: Shower Tray 0
Downstairs 3 Bathroom: Tap 0
Upstairs 4 Attic No
Upstairs 6 Attic No
Downstairs 6 Attic No
Outside 7 Attic No
Inside 4 Bathroom: downstairs 0
Inside 3 Bathroom: Upstairs 0
Downstairs 12 Larder No
Downstairs 14 Larder No

I need a formula that will look at the contents of column C and if it contains the word "Bathroom" - regardless of whatever comes after it, then to put a zero into document D otherwise put Yes into column D.

I have tried to use a wildcard:=IF(C2>="*Bathroom*.*",0,"No")

However, it shows 0 for everything.

Please help.

Thanking you all in advance.

Regards
Sue

 

[Eric W]

Hi Sue,

Try:

=IF(COUNTIF(C2,"*bathroom*"),0,"Yes")

 

[suet]

Hi Eric

That worked a treat!!!

Thank you very much.

Much appreciated.

Regards
Sue

 

[Eric W]

Happy to help!