We help IT Professionals succeed at work.

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?
Comment
Watch Question

CERTIFIED EXPERT

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

Author

Commented:
here's a sample book.  thanks.
Book3.xlsx
CERTIFIED EXPERT
Commented:
To match both name and address use
=COUNTIFS('Sheet1 (2)'!$B$1:$B$13,Sheet1!B2,'Sheet1 (2)'!$C$1:$C$13,Sheet1!C2)>0

To match only address use
=COUNTIFS('Sheet1 (2)'!$C$1:$C$13,Sheet1!C2)>0

In D2 and copy down.
Todd WSystems Administrator

Author

Commented:
easy nuff!  thank you Saqib