USD $30: Extract number from a text string based on match (OZGRID PAID)

  • Hi...I am looking for a formulas in cells B2:E4 that will extract a number from Column A based on a text match from the column header. The trick is that the number is to the left of the text match. Below is an example what I'm looking to accomplish. Let me know if you have any ?'s. Thanks in advance for your help. 10% pre-pay sent via PayPal.


    [TABLE="width: 697"]

    [tr]


    [td][/td]


    [td]

    [TABLE="class: grid, width: 500, align: left"]

    [tr]


    [td]


    [/td]


    [td]

    Col A

    [/td]


    [td]

    Col B

    [/td]


    [td]

    Col C

    [/td]


    [td]

    Col D

    [/td]


    [td]

    Col E

    [/td]


    [/tr]


    [tr]


    [td]

    Row 1

    [/td]


    [td]

    Splits

    [/td]


    [td]

    EMEA-EI

    [/td]


    [td]

    EMEA-FAS

    [/td]


    [td]

    EMEA-IMS

    [/td]


    [td]

    EMEA-TRS

    [/td]


    [/tr]


    [tr]


    [td]

    Row 2

    [/td]


    [td]

    100.00 [EMEA-FAS]

    [/td]


    [td][/td]


    [td]

    100.00

    [/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Row 3

    [/td]


    [td]

    50.00 [EMEA-EI]; 50.00 [EMEA-IMS]

    [/td]


    [td]

    50.00

    [/td]


    [td][/td]


    [td]

    50.00

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    Row 4

    [/td]


    [td]

    50.00 [EMEA-EI]; 25.00 [EMEA-FAS]; 25.00 [EMEA-TRS]

    [/td]


    [td]

    50.00

    [/td]


    [td]

    25.00

    [/td]


    [td][/td]


    [td]

    25.00

    [/td]


    [/tr]


    [/TABLE]

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [/TABLE]

  • Re: USD $30: Extract number from a text string based on match (OZGRID PAID)


    Hello,


    I will have a look at it and get back to you with feedback.


    Wigi

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: USD $30: Extract number from a text string based on match (OZGRID PAID)


    Okay I got it, I will set up formulas.
    Either native Excel formulas, either a VBA solution if native formulas would be too clumsy.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: USD $30: Extract number from a text string based on match (OZGRID PAID)


    Hello,


    I have a formula solution and also a custom function (UDF) for you. Up to you to choose what you like best.
    After a PayPal payment (I will send you my ID in a private message) I will upload the solutions.


    See picture please:
    [ATTACH=CONFIG]70066[/ATTACH]


    Best regards,


    Wigi

    Files

    • 00.jpg

      (27.36 kB, downloaded 13 times, last: )

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: USD $30: Extract number from a text string based on match (OZGRID PAID)


    Payment received, thanks !
    Solution attached.

    Files

    • Book1.xlsm

      (14.35 kB, downloaded 16 times, last: )

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

  • Re: USD $30: Extract number from a text string based on match (OZGRID PAID)


    Thank you ! :-)
    You're welcome.

    Regards,


    Wigi


    Excel MVP 2011-2014


    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes


    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --