I have these 2 columns
house in washington House purchases house in detroit House purchases purchased car blue car purchased in delaware Car purchases iowa house in House purchases
Every time that Excel finds in column A the words "house in", I want to populate column B with the words "House in city" (which refers to the category). Similarly, if Excel finds in column A the words "car purchased "or "purchased car", I want to populate column B with the category "Car purchases". I tried using IF statement, but it's not working. The thing is that I am not looking for an exact value. If the words "house in" are in the cell, it doesn't matter if there is a 3rd word describing the city or the state, it should be classified in the ''House purchases'' category. I need to finish this by tomorrow. Any quick insights you can provide would be very much appreciated. Thank you again.
Bookmarks