Need Boolean logic? to compare data

[SuzyQPA2]

I have 2 columns of data with multiple rows

Column A
Row 1 - EE spouse

Column B
Row 1 - Employee Spouse

I want in Column C Row 1 to have the match formula say True or Yes even though the data is only a close match. I want to use a wildcard so the formula is like this:

in Column C
Row 1 =if(A1=*b1,"yes","no")

I want this comparison to happen row by row in column C, I don't want to conditional format Column A to equal Column B because i import the data from different systems.

 

[Andrew Poulsom]

Can you give some examples? The COUNTIF function accepts wildcards.

 

[SuzyQPA2]

Excel Workbook
	A	B	C	D
1	Employee name	Data from System 1	Data from System 2	Match?
2	Jane Doe	EE Spouse	Employee Spouse	TRUE
3	Eric The Red	Single	Single	TRUE
4	Mickey Mouse	EE Spouse	Employee Spouse	TRUE
5	Steve Jobs	EE Family	Employee Family	TRUE
6	Gloria Steinhem	Single	Employee Spouse	FALSE
Sheet1

 

[Andrew Poulsom]

For that data, in D2 copied down:

=COUNTIF(C2:C2,"*"&B2)>0

 

[SuzyQPA2]

Super cool - thanks!

 

[SuzyQPA2]

Super cool - thanks!

I have an error coming up for EE child vs Employee Children can you allow for that in the formula? If not it's ok.

 

[Andrew Poulsom]

Try:

=COUNTIF(C2:C2,"*"&B2&"*")>0