I have a list of names and locations. Most of the locations include the name of the province or state. Some only include country names, some include state abbreviations.
I also have a list of provinces and states and which country they belong to, with common abbreviations.
How do I search the text of the Location column
B for an inexact match, referencing the names of the states
E:H, and return the Country that they belong to column