Comparing two columns in different sheets
In Sheet1 I have peoples names and addresses. Names in column A, and addresses in B-column like this:
Mystreet 23, 2.th.
Your Street 5, aptm. 345
Carl Bark Street, 4.th.
Hollowgate 2
and so on.
In sheet 2, Column A I have list of street names like
Carl Barks Street
Hollowgate
Mystreet
Your Street
and so on.
What I need to do is compare the street name part of the address (Sheet 1, column B) with the list of street names (sheet2, column A) and mark all the adresses where the street name doesn't have a match in the list of street names. In the above example the list of adresses contains the name Carl Bark Street, which is incorrect as the name in ther list is Carl BarkS Street. So it has to marked. Sio does streets with extra blanks, or street that do not exist at all.
The challenge for me is that the road names can have none to several blanks in them, and what follows the road name in the addresses also have different content.
Is it possible at all to do something like what I want.
|