I want to pull specific word "like Product campaign, Brand, Generic, in label colum by using vlookup. i cannot use Mid or right function because there are so many campaign and those words are not in order in term of using right mid or left formula. please see the example below.
Or is there is any other way of getting this words in label colum. please help. thanks
B3 - UK - Product Campaign
B3 - US - Product Campaign
B3 - UK + ROW - Non Gender - Generic - Shoes - General
B3 - US - Mens - Generic - Shoes - General
B3 - US - Non Gender - Generic - Shoes - General
B3 - US - Non Gender - Brand - Misspell
B3 - US - Womens - Generic - Shoes - General
B3 - UK - Non Gender - Brand - General
B3 - UK - Womens - Generic - Shoes - Trail
Hi Ahemed,
Welcome to the forum and thanks for sharing an example file.
You can use an INDEX formula to find a partial match to the values in column B, but it requires the lookup words to be unique. e.g. 'Gen' and 'Generic' are both present in many of the items in column B so this results in the wrong answer. See file attached.
If you can make the lookup values unique and remove ambiguity then the formula will work.
Mynda
Great so sweet of you. Thanks
