I have a Home Budget spreadsheet in Apple Numbers (version 6.2.1 (6529)) of purchases I’ve downloaded from a .csv file. It lists all my credit card transactions – each row includes the name of the Retailer, Date, and Amount of each purchase in separate columns. I’m trying to add a column to my spreadsheet that uses a formula to categorize the “Type” of purchase, based on the name of the retailer.
For example: If the Retailer field contains “Farm Boy” (a grocery store) then I want “Food” to appear in the “Category” column. Note: There are approximately 6-8 different store names in the Retail field that should result in “Food” being generated in the “Category” column. There are also other categories with similar dynamics, eg. Retailers for gas stations or parking lots that I would want to generate “Auto” in the Category column for those transactions.
Is there a way to do this Numbers?