- 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?