Sheet A has a list of restaurant names from around the country:
Restaurant | City The Bar and Grill Tampa | ... Oklahoma City's Best Bar | ...
Sheet B is a list of all US cities:
Tampa Oklahoma City
How do I get the correct city to populate into the City column in Sheet A? This shouldn't be complicated, as I'm basically saying look at Sheet B, if Sheet A contains a City from Sheet B, then list city in Sheet A. But I can't find a solution anywhere that works.