Avatar of Todd W
Todd W
Flag 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?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Todd W

8/22/2022 - Mon
Saqib Husain

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

ASKER
here's a sample book.  thanks.
Book3.xlsx
ASKER CERTIFIED SOLUTION
Saqib Husain

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Todd W

ASKER
easy nuff!  thank you Saqib
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes