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

#### 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

#### bharath

##### Member
Hi,

I think better to use pivot table for this.
If it is suitable to your work data.

#### AmberAshley

##### New Member
Hi,

I think better to use pivot table for this.
If it is suitable to your work data.
Unfortunately, it has to be a lookup as I will be bringing the data from other system.

#### 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))