If cell A1 contains a certain substring in it, I'd like to return a value in cell B1. For instance, if cell A1 contains a city such as "Los Angeles" in it, I would like to return its region in cell B1, which is "West." Or, if that same cell A1 contains another city, such as "Boston," I'd like cell B1 to return "East." Does anybody have a formula to achieve this?
Thanks.
Bookmarks