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:

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.