• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sum of matching individual Vlookup values for a cell having comma separated values [SOLVED]

AmberAshley

New Member
My lookup table (Sheet2) looks likes below
ItemEfforts
Google10
Facebook20
Instagram30
Twitter40

My entry sheet can be as below
GoogleExpected: 10 [Fairly simple and Solved]
Google, FacebookExpected: 10+20=30 [No idea how to do it]
Facebook, Twitter, InstagramExpected: 20+40+30=90 [No idea how to do it]
Twitter, FacebookExpected: 40+20=60 [No idea how to do it]

I am not sure how I can I do the sum for vlookup. Any help will be appreciated
 

vletm

Excel Ninja
AmberAshley
If You would like to solve Your challenge then
You should upload here its needed sample files with expected correct results.
If only 'lookup' is Your accepted solution, then ... maybe okay?
... or would You solve Your challenge?
 

AmberAshley

New Member
AmberAshley
If You would like to solve Your challenge then
You should upload here its needed sample files with expected correct results.
If only 'lookup' is Your accepted solution, then ... maybe okay?
... or would You solve Your challenge?
I was about to upload but that would have be more confusing hence, I explained it in description.

Anyways, I did get my answer so I will be requesting/closing the thread.
Thank you.
 

AmberAshley

New Member
I got the answer. Below is the array formula to get it done. Mind you: This is an Array Formula and not the normal formula.

=SUM(IF(ISNUMBER(FIND(", "&Sheet2!A$1:A$7&", ",", "&A1&", ")),Sheet2!B$1:B$7))

This thread can be closed.
 
Top