AmberAshley
New Member
My lookup table (Sheet2) looks likes below
My entry sheet can be as below
I am not sure how I can I do the sum for vlookup. Any help will be appreciated
Item | Efforts |
10 | |
20 | |
30 | |
40 |
My entry sheet can be as below
Expected: 10 [Fairly simple and Solved] | |
Google, Facebook | Expected: 10+20=30 [No idea how to do it] |
Facebook, Twitter, Instagram | Expected: 20+40+30=90 [No idea how to do it] |
Twitter, Facebook | Expected: 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