+ Reply to Thread
Results 1 to 50 of 50

Vlookup value after comma+space and add the values till last comma+space in the series

  1. #1
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Vlookup value after comma+space and add the values till last comma+space in the series

    I have a query which I am unable to solve.

    I have certain Codes in Sheet1 as below

    A B C
    1 CODES OUTPUT SUM
    2 991121QR5, 991121XSX, 991234SSC, 991121SDF
    2 991121QR5, 991121XSX, 991234SSC
    2 991121QR5, 991121XSX, 991234SSC, 991121SDF

    Table in Sheet 2 is as follows:-
    A B
    1 CODES VALUE
    2 991121QR5 100100
    3 991121XSX 888888
    3 991234SSC 123456
    4 991121SDF 121212

    The Final Outcome in Sheet 1 should be as follows:-
    A B C
    1 CODES OUTPUT SUM
    2 991121QR5, 991121XSX, 991234SSC, 991121SDF 100100, 888888, 123456, 121212 1233656
    2 991121QR5, 991121XSX, 991234SSC 100100, 888888, 123456 1112444
    2 991121QR5, 991121XSX, 991234SSC, 991121SDF 100100, 888888, 123456, 121212 1233656


    How can I get the above OUTCOME using one single formula to vlookup each value from cell A2 after comma+space from sheet1 with the table in sheet2 and place the output in same format as in cell a2 of sheet 1 in cell b2 of sheet 1. Also how to add up all the values of b2 in c2.

    I have posted the same in other forums but have not received any solution as per requirement.

    https://chandoo.org/forum/threads/vl...comma-s.36769/

    https://www.mrexcel.com/forum/excel-...pace-cell.html

    https://www.excelforum.com/excel-for...he-series.html

    https://www.ozgrid.com/forum/forum/h...by-comma-space
    Last edited by sandeepsandeep; 12-22-2017 at 01:46 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Is this what you had in mind? VBA is needed, so enable macros.

    Happy to explain.

    PS, next time add an Excel sheet. it saves us a lot of time replicating your set-up.

    The formula used in b2 is an arrray formula.

    Array Formulae are a little different from ordinary formulae in that they MUST be confirmed in the FIRST CELL ONLY by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. After that, the array can be dragged down as normal, to cover the desired range.

    You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

    Don't type the curly brackets yourself - it won't work...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Thanks that is great. But what if the code has no value. Then in this case the sum should show an error. Can this be included as well.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Your new request is not clear. Does the code exist, but has no value, or does the code not exist?? How do you want the result to be displayed? Please attavh a sample sheet, showing you expected result (no guarantees, as I am not much use with VBA!!)

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

  5. #5
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    is sum enough or also need column b (output) too
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  6. #6
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by nflsales View Post
    is sum enough or also need column b (output) too
    I need both the coloumns

    Glenn Kennedy's Macro is working at the moment.

  7. #7
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by Glenn Kennedy View Post
    Your new request is not clear. Does the code exist, but has no value, or does the code not exist?? How do you want the result to be displayed? Please attavh a sample sheet, showing you expected result (no guarantees, as I am not much use with VBA!!)

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    I have attached the file.
    Attached Files Attached Files

  8. #8
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    maximum how many codes you have in column at any point of time?

  9. #9
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I have included a remarks coloumn explaining what changes I have made and what result I would expect.

  10. #10
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,904

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I mean in column A in single cells maximum no of possible codes at any point of time

  11. #11
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    40 max codes

  12. #12
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Any progress made on formula?

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,410

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Rule 08: Cross-posting Without Links

    You have already ignored a cross-post warning on another forum - DO NOT IGNORE THIS REQUEST!


    Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    No further help to be offered, please, until the OP has complied with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  14. #14
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    The needful is done. Once the solution is sought I will change the status to SOLVED. Thanks Moderator for drawing my attention towards this.

  15. #15
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    First thing you must fill blank cell in sheet 2

    Select b column then press control+G->click on special ->check mark on blank->all the blank cell now highlighted -> give = and left cell then press control+enter.

    Now in sheet1

    E2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

    Copy towards the cells and down. There are helper columns.

    B2
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Copy down.

    Row\Col
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    1
    CODES OUTPUT SUM Helper column Helper column Helper column Helper column Helper column Helper column Helper column
    2
    991121QR5, 991121XSX, 991234SSC, 991121SDF 100100,888888,991234SSC,121212 1110200
    100100
    888888
    991234SSC
    121212
    3
    991121QR5, 991121XSX, 991234SSC 100100,888888,991234SSC #NA
    100100
    888888
    991234SSC
    4
    991121QR5, 991121XSX, 991234SSC, 991121XYZ 100100,888888,991234SSC,#NA #NA
    100100
    888888
    991234SSC #NA


    Sum part in column C I could not understand.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  16. #16
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I have some doubts.

    01. Why should i put the formula in E2 in Sheet 1?
    02. I want an error (#NA or #value or anything) if the code is there without value or code is not there at all in sheet 2.

  17. #17
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    1 These are helper column to produce value for achieving desired result.
    2 Whatever error would be there they are presenting in desired result.

    Check the attached file.

    How do you wish C column extract sum result?

  18. #18
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Try this modification.
    Attached Files Attached Files

  19. #19
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by Glenn Kennedy View Post
    Try this modification.
    This works the best. But It hangs my excel sheet where the table in sheet2 has more than 4000 codes with values in B2. How to solve that.

  20. #20
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Please Login or Register  to view this content.
    Click RUN on Sheet1
    Attached Files Attached Files

  21. #21
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    ... mod required

    Please Login or Register  to view this content.
    ..

  22. #22
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    ... mod required

    Please Login or Register  to view this content.
    ..
    thanks for your help but its not giving the correct result. It adds a "missing value" for a new row added in sheet2.

  23. #23
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Post file illustrating problem

    Adding to Sheet2 works for me.
    Last edited by JohnTopley; 12-22-2017 at 10:05 AM.

  24. #24
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by Glenn Kennedy View Post
    Try this modification.
    This is very close to perfection. Just a small help required that will close the matter.
    Whenever there is a value which is not there in sheet2 only that value should show as "missing code" in sheet 1 col B2 and not just "Missing codes".
    e.g. B2 would look like 100100, 888888, 121212, Missing Code and sum would show an error.

  25. #25
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I would still like to know what the problem is with my VBA solution.

  26. #26
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    I would still like to know what the problem is with my VBA solution.
    Ok Bro Following are my observation with your macro:-

    It does not add a space after the comma in B2 OF SHEET1 i.e. instead of 100100, 888888, 121212 it shows 100100,888888,121212.
    Also, If I my first cell starts from S1 instead of A1 then how to change the same in macro?

    If you add that in your macro then this would complete my requirement. Apart from this I dont see any problem using your macro.
    Last edited by sandeepsandeep; 12-22-2017 at 01:24 PM.

  27. #27
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Pretty minor... new code...

    Please Login or Register  to view this content.

  28. #28
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Great. Also, If I my first cell starts from S1 instead of A1 and goes upto S200 then how to change the same in macro?

  29. #29
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Please Login or Register  to view this content.
    See attached: assumes data is from column S onward

    Code changes highlighted
    Attached Files Attached Files

  30. #30
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    There are two modules in this sheet.
    Is Module 2 required?

  31. #31
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Thanks for jumping in JT. My VBA isn't up to much!!

  32. #32
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    No: Module 2 can be deleted

  33. #33
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    No: Module 2 can be deleted
    Now i m am getting a debug error when i am renaming sheet1 as "Final" and Sheet2 as "Table"
    Error is as follows

    cSum = cSum + (var + 0)

  34. #34
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by Glenn Kennedy View Post
    Thanks for jumping in JT. My VBA isn't up to much!!
    You created a useful macro and I will explain in detail about the limitations I faced so that your macro cn also be modified to suit the final output.
    Last edited by sandeepsandeep; 12-22-2017 at 02:13 PM.

  35. #35
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I am not good enough to fix it. Take it or leave it as it is!! Sorry....

  36. #36
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by sandeepsandeep View Post
    Now i m am getting a debug error when i am renaming sheet1 as "Final" and Sheet2 as "Table"
    Error is as follows

    cSum = cSum + (var + 0)
    I think if this is resolved then most of the issues would get resolved comletely.

  37. #37
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,900

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I do hope that you do realize that your data layout is really bad... and that this whole thing could be made MUCH simpler by using a simple formula to split the codes in the multi-code cells into separate cells....

  38. #38
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Just change VBA references to "Sheet1" and "Sheet2" to "Final" and "Table"

    Set ws2 = Worksheets("Table")

    Set ws1 = Worksheets("Final")

    and you can change to

    cSum = cSum + var

    (this was not the error!)

  39. #39
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    .... and I echo Glenn's comment: I cannot understand, that with 16K columns available, there is a common persistence in grouping data in a single cell/column.

  40. #40
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    Just change VBA references to "Sheet1" and "Sheet2" to "Final" and "Table"

    Set ws2 = Worksheets("Table")

    Set ws1 = Worksheets("Final")

    and you can change to

    cSum = cSum + var

    (this was not the error!)
    I did as u said but I am getting a Run-Time error '13': Type Mismatch
    cSum = cSum + var

  41. #41
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Well it works for me with your test file.

    This suggests a data problem i.e. the value is non-numeric.

  42. #42
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    .....extra code to check value ..


    Please Login or Register  to view this content.

  43. #43
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    .....extra code to check value ..


    Please Login or Register  to view this content.
    Now it says compile error: Next without for

  44. #44
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    See attached ...
    Attached Files Attached Files

  45. #45
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by JohnTopley View Post
    See attached ...
    Thanks a lot bro. Its working like a gem. Thanks for your patience. Appreciate it. Finally the solution is sought. This thread can now be closed.

  46. #46
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,410

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  47. #47
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    It's a pity that people have put so much work for nothing at MrE...
    I will remember it

  48. #48
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,410

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    The OP needs to make sure he doesn't do this again, otherwise he might find himself unable to get help anywhere.

  49. #49
    Registered User
    Join Date
    12-21-2017
    Location
    India
    MS-Off Ver
    2010
    Posts
    24

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    Quote Originally Posted by Pepe Le Mokko View Post
    It's a pity that people have put so much work for nothing at MrE...
    I will remember it
    i DIDNT GET WHAT YOU MEAN BY THE ABOVE. I have already appreciated and thanked the member who helped me and added reputation also. What else is required to be done?

  50. #50
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,007

    Re: Vlookup value after comma+space and add the values till last comma+space in the series

    I think this is related to cross-posting on multiple forums.
    Last edited by JohnTopley; 12-23-2017 at 06:09 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove space before comma if exists
    By wholly1971 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-23-2016, 12:38 AM
  2. Comma delimited numbers with space after comma
    By Cicada in forum Excel General
    Replies: 5
    Last Post: 04-23-2015, 09:32 AM
  3. [SOLVED] Convert space between first and last name to comma
    By Vaslo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-04-2014, 03:06 PM
  4. [SOLVED] Replace space to comma
    By rarementality in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2014, 09:15 AM
  5. Replies: 7
    Last Post: 02-10-2013, 02:10 AM
  6. Macro inserting comma & space
    By katmison in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2012, 10:24 PM
  7. Removing a space after a comma
    By DebbieK9 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 04-01-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1