# Thread: Vlook up & concatenate

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. Is there any possibility to solve the problem? I checked the data, but cannot find/eliminate the cause

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

4. Originally Posted by dreschkov
It is working now
Can you please share the method with us about how you made it to work for our knowledge base

5. 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. Thanks for the info

7. 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"?

8. 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 First 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
•