Search a specific word from list and insert in new column

[shahmed]

SKU.JPG

I am trying to search words in column A and if it matches the words from the Gender list (column D), It should say in column B.?

For example, A9 has the word Unisex then the result in B9 should b UNISEX

any advice.SKU.xlsx

[Squeaky]

Hi Shahmed,

Here is my solution to this. There are irregularities in your form. You have standard case in some words and not in others such as Men, BOY, GIRL, Infant, etc.
I used the capitalized form of BOY and GIRL, but also added the standard case version.
I created a chart to the right of your list and used the names you want to look for at the top, and divided the compound words such as Women_Junior into separate categories
because they are not found in the description in that manner, but combines them again if they are found. The chart portion looks for the word in the description and displays that word if it finds it below the chart. You will notice that Women_Junior will display if found in either column. Same with the rest.
Column B will display the words it finds in the chart. The FIND formula is case sensitive. To make this work in a full list simply drag down the formulas in B9, and F9-O9. You can add words to the next columns P
and beyond by dragging the formulas in O over there, however you will need to modify the formula in column B to account for the extra columns in the chart area. You should be able to study that formula to see how
to do it.

Cheers.
Squeaky

[shahmed]

Amazing. it worked perfectly. thank you for your help. much appreciated.