Nov 25 2021 02:28 AM
Hi, I have a list of data, that I need to separate as one of two categories, is there is formula for that?
Nov 25 2021 04:25 AM
@Sogol7988 That's rather vague. How does the data look like? Can you upload a file, perhaps?
Nov 25 2021 04:27 AM
I have a column that contain name of product, and I need to separate them as food or drink, on the second column I need to show if they are food or drink.
Nov 25 2021 04:38 AM
@Sogol7988 That will be a challenge if don't already have a comprehensive list of all possible food and drinks. With such a list you could use several functions (VLOOKUP, INDEX with MATCH, XLOOKUP). But without such a list Excel doesn't know that tea is a drink and bread is food.