There is probably some simple formula for this action, but I don’t know what it is. I want to import data into a spreadsheet and then be able to add a column that will automatically tag or label that column based on the text in another column. For instance
If B2 has the words “Shell” then D2 has the word “Gasoline”. If B3 has the words “McDonalds” then D3 displays the word “Fast Food”. Once an association is chosen, then it makes the same choice throughout the sheet.
Check out the help for function VLOOKUP. The example there is similar to what you want to achieve.