Forum Discussion

rg1008's avatar
rg1008
Copper Contributor
Mar 08, 2020

Excel Search Text String from List within Cell and output found text

Hello,

 

I have a list of product descriptions (Column A) that contain the color and product type. I'm trying to separate the color into another column (Column C) so that I can sort by Design # (Column B) and then Color (Column C). I have a separate list of possible colors I would like to use to search with (Column E).

 

 

Any ideas on what to use for a formula?

 

Thank you for any suggestions 🙂

excel
Formulas and Functions
office 365

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 08, 2020

    rg1008 Attached something based on what I recently created in another topic in this forum. I believe it will work for you. Just make sure you enter your colours in the "keyword"-list (Named Range) in the correct order. Enter all the variations first, then just the "single colour". Have a look at the file and you'll understand.

     

    Let me know if you need more help.

    • MichaelSedlock's avatar
      MichaelSedlock
      Copper Contributor
      May 04, 2021
      Riny,
      Thank you, this is an awesome solution. Helped me get exactly what we needed.
      For those who may not know, to edit the "Keywords" click on Formulas, Name Manager. There you will see the "Keyword" list defined.
      Best Regards,

Resources