Page 2 of 2 FirstFirst 1 2
Results 11 to 18 of 18

Thread: Vlook up & concatenate

  1. #11
    Acolyte Sixthsense's Avatar
    Join Date
    Nov 2012
    Location
    India
    Posts
    26
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    The calculation process is not happening completely... In the status bar its showing the Calculate button which is not even making excel to complete the calculation and keep on showing the calculate button after hitting the F9 and Shift+F9 also...

    May be that is the root cause of this issue I believe

  2. #12
    Is there any possibility to solve the problem? I checked the data, but cannot find/eliminate the cause

  3. #13
    It is working now. Great stuff --> Thank you for the support!

  4. #14
    Acolyte Sixthsense's Avatar
    Join Date
    Nov 2012
    Location
    India
    Posts
    26
    Articles
    0
    Quote Originally Posted by dreschkov View Post
    It is working now
    Can you please share the method with us about how you made it to work for our knowledge base

  5. #15
    Actually, there was just a problem with the format of the cell or sth. else.
    After I dragged down your first formula
    =MyConcat(INDEX($D$8:$I$21,,MATCH(L10,$D$7:$I$7,0)),$C$8:$C$21,M10,$B$8:$B$21) and changed it to
    =SUMIFS(INDEX($D$8:$I$21,,MATCH(L10,$D$7:$I$7,0)),$C$8:$C$21,M10)
    it all worked out.

  6. #16
    Acolyte Sixthsense's Avatar
    Join Date
    Nov 2012
    Location
    India
    Posts
    26
    Articles
    0
    Thanks for the info

  7. #17
    Hi; I have to come back once more on the formula:
    =SUMIFS(INDEX($D$8:$I$21,,MATCH(L10,$D$7:$I$7,0)),$C$8:$C$21,M10)

    How can I include in the above formula a third IF: $D$8:$D$21 is not equal to "Other"?

    Thank you for your help in advance?

  8. #18
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,509
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =SUMIFS(INDEX($D$8:$I$21,,MATCH(L10,$D$7:$I$7,0)),$C$8:$C$21,M10,$D$8:$D$21,"<>Other")


Page 2 of 2 FirstFirst 1 2

Posting Permissions

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