Ask Your Question

How to tag, label or categorize in Calc automatically? [closed]

asked 2012-11-15 20:23:59 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 00:41:45.154328

1 Answer

Sort by » oldest newest most voted

answered 2012-11-16 00:10:52 +0200

horst gravatar image

updated 2012-11-16 01:43:08 +0200

Check out the help for function VLOOKUP. The example there is similar to what you want to achieve.

edit flag offensive delete link more

Question Tools


Asked: 2012-11-15 20:23:59 +0200

Seen: 1,005 times

Last updated: Nov 16 '12