Link to home
Start Free TrialLog in
Avatar of Todd W
Todd WFlag for United States of America

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?
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

How about a sample excel file with minimal or faked data to help understand and try to solve your problem?
Avatar of Todd W

ASKER

here's a sample book.  thanks.
Book3.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Todd W

ASKER

easy nuff!  thank you Saqib