|Just as a first pass suggestion, if you have more than a few strings to match (enough that would make a long Nested IF function cumbersome) you could use multiple columns (typically referred to as "Helper Columns") to extract each string and then Concatenate the results into Column F.|
For example, if you wanted to extract Audi and Music in your example, you could do this:
Set up a sheet to look like this:
C F G H
1 Raw Data Category Audi Music
2 Cars - Audi
3 Music - Audio
4 Audi - Q7
In G2, enter the following formula, then drag in down to G4, then over to H4
=IF(NOT(ISERROR(FIND(" "&G$1&" "," "&$C2&" "))),G$1,"")
This should extract the strings shown in G1:H1. You will note the leading and trailing spaces included the formula. This is done to ensure that "Audi" is extracted, but not "Audio".
Next, enter either one of these formulas in F2 and drag it down:
This will concatenate the values in G2 and H2, but since only one of those cells contains data, that is all that you will see in Column F.
Obviously, you will need a column for each string that you want to extract and a Concatenation formula that references all columns used. You do not have to put the Helper Columns in G and beyond, in fact they don't even need to be on the same sheet. You can use another sheet (and even Hide it) to hold those columns and then reference them with the Concatenation formula.
Let me know if that works for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.