20 Replies Latest reply: Jun 3, 2015 10:17 AM by Ramon Covarrubias RSS

    Find Value in Text and "Vlookup" value

    Martin Wosnitza

      Dear all,

       

      I hope you had all a good start into the week... I have the following problem where I would need your brains :

       

      I would like to find a value (forced package) in a text and "vlookup" the Code & Package value.

       

      The text is the following for the MCode ABCDEF: "A32, W98, XXD, BCD, W11"

      As a result it should show me "ABCDEF - Pack.2"

       

      So it has to recognize the right MCode and find the forced package code in the text to give me the right Code & Package value.

       

      MCodeForced PackageCode & Package
      ABCDEFW94ABCDEF - Pack.1
      ABCDEFW98ABCDEF - Pack.2

       

      What kind of formula do I have to use to get to this result?


      Thanks for any kind of hints and solutions!!

       

      Cheers

      Martin