Hello
I am attempting to carry out some address matching and wondered if someone could help.
I have one list of addresses which just contain the house number and street name....and I need to match this against a longer list of addresses which contain the full address (inc. town, county, zip code)
Column A Column B
full address id
Row 1 20 High Street TownName Nottinghamshire NG4 2AA
Row 2 40 Main Road TownName Nottinghamshire NG4 2AA
Row 3 42 High Street Street TownName Nottinghamshire NG4 2AA
Row 4 45 Main Road TownName Nottinghamshire NG4 2AA
So I need to take the address in sheet 1 cell A1 and compare it against a range in a separate sheet - Sheet2!$A$1:$A$4
Column A
short address
Row 1 20 HIGH STREET
Row 2 22 MAIN ROAD
Row 3 45 MAIN ROAD
Row 4 22 HIGH STREET
and if it matches then return a GH in Column B on the first sheet
Any help would save me a lot of time manually matching
Bookmarks