Formula

Copper Contributor

Hi, I have a list of data, that I need to separate as one of two categories, is there is formula for that?

3 Replies

@Sogol7988 That's rather vague. How does the data look like? Can you upload a file, perhaps?

@Riny_van_Eekelen 

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.

@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.