I have a large database of 40,000 records:
Sheet 1: Column A City, Column B Hotels, Column C Address
Sheet 2: Column A City, Column B Hotels(the names are same but not have any uniform format).
I want to match sheet 1 & sheet 2 and pick up the addresses of corresponding hotels. A hotel exists in
more than one city. I have been able to pick up the addresses where Hotel name is same exactly but
where ever the hotel name doesn't matches exactly, I am not able to pick up the address. kindly help.
Sheet1
Column A Column B Column C
=================================================
City Hotels Addresses
=================================================
Amsterdam Aadam Wilhelmina Hotel Koninginneweg 169
Amsterdam Abba 1054 HM Amsterdam
Amsterdam Odeon Pireos 42
Athens Abba Narody 654
Sheet2
Column A Column B
========================
City Hotels
========================
Amsterdam The Odeon Hotel
Amsterdam Abba Hotel
Amsterdam Aadam Wilhelmina Hotel
Athens Abba Athens
The required final output:
Column A Column B Column C
=================================================
City Hotels Addresses
=================================================
Amsterdam The Odeon Hotel Pireos 42
Amsterdam Abba Hotel 1054 HM Amsterdam
Amsterdam Aadam Wilhelmina Hotel Koninginneweg 169
Athens Abba Athens Narody 654
Sheet 1: Column A City, Column B Hotels, Column C Address
Sheet 2: Column A City, Column B Hotels(the names are same but not have any uniform format).
I want to match sheet 1 & sheet 2 and pick up the addresses of corresponding hotels. A hotel exists in
more than one city. I have been able to pick up the addresses where Hotel name is same exactly but
where ever the hotel name doesn't matches exactly, I am not able to pick up the address. kindly help.
Sheet1
Column A Column B Column C
=================================================
City Hotels Addresses
=================================================
Amsterdam Aadam Wilhelmina Hotel Koninginneweg 169
Amsterdam Abba 1054 HM Amsterdam
Amsterdam Odeon Pireos 42
Athens Abba Narody 654
Sheet2
Column A Column B
========================
City Hotels
========================
Amsterdam The Odeon Hotel
Amsterdam Abba Hotel
Amsterdam Aadam Wilhelmina Hotel
Athens Abba Athens
The required final output:
Column A Column B Column C
=================================================
City Hotels Addresses
=================================================
Amsterdam The Odeon Hotel Pireos 42
Amsterdam Abba Hotel 1054 HM Amsterdam
Amsterdam Aadam Wilhelmina Hotel Koninginneweg 169
Athens Abba Athens Narody 654