In the below example, I want to analyze each cell in column A, and if the cell’s contents match certain parameters, return a value in column B accordingly. So if the value in a col A cell = apple, banana or pineapple, it should return a value of “Fruit” in col B for that item. Or if the value of a cell in col A = truck or motorcycle, it should return “Vehicle” in col B.
Haven’t been able to figure this one out
Go to Source
Author: Ben Dickey