Need Boolean logic? to compare data

S

SuzyQPA2

Board Regular
Joined
Oct 28, 2004
Messages
90
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.
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Sort by date Sort by votes
Excel Workbook
ABCD
1Employee nameData from System 1Data from System 2Match?
2Jane DoeEE SpouseEmployee SpouseTRUE
3Eric The RedSingleSingleTRUE
4Mickey MouseEE SpouseEmployee SpouseTRUE
5Steve JobsEE FamilyEmployee FamilyTRUE
6Gloria SteinhemSingleEmployee SpouseFALSE
Sheet1
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question
need to compare data in one column to another...
Replies
7
Views
80
Cubist
Cubist
T
  • Question
Compare spreadsheet/worksheet with changing rows
Replies
2
Views
84
BenW71
B
E
  • Solved
This one is tricky. VLookup but return a different cell value
Replies
6
Views
182
Alex Blakenburg
A
DNapoli
  • Solved
Index and Match Excel Question.
2 3
Replies
24
Views
443
Peter_SSs
Peter_SSs
X
  • Question
Macro to fill an identifier down and SUMIF
Replies
4
Views
167
xbrianx
X

Forum statistics

Threads
1,214,971
Messages
6,122,517
Members
449,088
Latest member
RandomExceller01

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top