Searching Columns A and B for Specific Values and Returning '1' in Column C if 'True'

[Tomasome]

Hi all, long time lurker, first time poster. Thanking you in advance.

I am attempting to do some analysis on calls into a call center and I have a large spreadsheet that contains a call category and call description. Essentially, what I want to do is search column A for 'Category X' and subsequently search the corresponding call description in Column B for a specific code. Then, if there is a match, I want to put the value '1' for a match in column C and '0' if not found.

Lets say column A contains three categories: i.e. Operations, Claims, Sales.
Lets say column B contains any random string of text: i.e. string of text is for code 0000, string of text is for code 0000, string of text is for the code 1111

So, say I want to search all the text in column B for the code '0000' where the category in column A is 'Operations' and subsequently put the value 1 in the corresponding cell in column C.

How would I go about doing this?

 

[gaz_chops]

Try
=SUMPRODUCT((A1:A100="Category X")*(B1:B100="Code 1111"))

 

[gaz_chops]

The above will show 0 if not found and 1 if found once, 2 if twice etc.
Below will show 0 if not found, 1 if found regardless of number of uccurances.
=IF(SUMPRODUCT((A1:A100="Category X")*(B1:B100="Code 1111"))>=1,1,0)

 

[Tomasome]

The above will show 0 if not found and 1 if found once, 2 if twice etc.
Below will show 0 if not found, 1 if found regardless of number of uccurances.
=IF(SUMPRODUCT((A1:A100="Category X")*(B1:B100="Code 1111"))>=1,1,0)

Many thanks Gaz but this actually didn't work at all. I have found another two formulas that do the trick;

1. =AND(A2="Operations",ISNUMBER(SEARCH("0000",B2)))*1

2. =SUMPRODUCT((A2="Operations")*(RIGHT(B2,4)="0000"))