mardi 31 janvier 2017

Excel -- how to return certain values if cells in a column match multiple criteria

I want to search for certain values in a column and return specific words based on those values.

In the screenshot below, I'd like rows B-D to function as one. So only return "Pumpkin Pie", "Cookies", and "Rice". The rest will fall into "Other"

Screenshot

Aucun commentaire:

Enregistrer un commentaire