Excel - filtering, sorting?

[feliks27]

Hay everyone!
I have one problem in Excel and I'll try to explain it. It is comple
table (with formulas, etc.) but I have problem with one column. In thi
column are "Products" - all kinds, but I have to make sort withi
categories- category of "carbonated" and "non-carbonated" product. I
all this table it is no specification which product is "csd" o
"noncsd". So, my problem is how can I make filter for categorie
if there is no specification? This table I got it because they wan
filter for "csd" and "noncsd". I have tried on a new sheet to specif
those categories for each brand and flavour but I do not know how t
link (or something else) it with existing sheet that have all th
data.
Can you help me, please. Thnaks!:

 

[Debra Dalgleish]

If you have another table with the carbonation information for each
product, you could use a VLookup formula to return the data in the
complex table. There's information here on VLookup:

http://www.contextures.com/xlFunctions02.html