Todd W
asked on
Matching data in 2 separate excel tabs
- I have 2 tabs of data (multiple columns, multiple rows)
- each of these tabs contains a column with only the street address (ex: 123 Somewhere Street), no city, st, zip)
- on tab A, all street address fields are entered so there no blanks
- on tab B, there could be blanks in this street address column
I'm trying to see if an address in street address column on tab A matches exactly to a street address on tab B and either use another column to say true or false on Tab A, or even better, highlight the matching text on both tabs.
Any clue how to accomplish this?
How about a sample excel file with minimal or faked data to help understand and try to solve your problem?
ASKER
here's a sample book. thanks.
Book3.xlsx
Book3.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
easy nuff! thank you Saqib