Lookup text from one sheet into another and sum the similar text values

[irfanparbatani]

Hi Friends

I have a scenario, there is values in sheet 1 column B and i have to match them with Coulmn B, Column C and if there is a match of first word in a cell add the values which is in Coulmn D.

Please help me with the above scenario.

Thanks in advance.

[FDibbins]

You give very little to work with But take a look at using the sumif() function

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[irfanparbatani]

Hi

Example sheet attached, I want to find total value in Column D, lookup value from sheet 2 and sum all the identical values from cell.

Thanks for responding

[FDibbins]

Not really sure of the purpose of column B?

	A	B	C	D
1				Total Value
2	My Name Is	10		1220
3	My Name	20		1220
4	XYZ	30		500
5	XYZA	50		500
6	ABCDE	90		100
7	ANVI	80		520
8	ANV	60		1055

D2=SUMIF(Pivot!$B$4:$B$13,Sheet1!A2&"*",Pivot!$C$4:$C$13)
copied down

If that was not what you wanted, please provide some sample answers - and how you got them

[irfanparbatani]

Not really sure of the purpose of column B?

	A	B	C	D
1				Total Value
2	My Name Is	10		1220
3	My Name	20		1220
4	XYZ	30		500
5	XYZA	50		500
6	ABCDE	90		100
7	ANVI	80		520
8	ANV	60		1055

D2=SUMIF(Pivot!$B$4:$B$13,Sheet1!A2&"*",Pivot!$C$4:$C$13)
copied down

If that was not what you wanted, please provide some sample answers - and how you got them

-----------
Here is the formula but its giving me everything and the values is not consistent with what i am searching.

=SUMPRODUCT(SUMIF(Pivot$B:$C,LEFT(A1,FIND(" ",A1&" ")-1),Pivot!$C:$C))

Please suggest.

[FlameRetired]

Not clear but your formula almost looks like it's trying to do what this does:

Please Login or Register  to view this content.

[FDibbins]

Did you try my suggestion?

[irfanparbatani]

Did you try my suggestion?

Hi

I tried your solution, but still not working for searching the first word from pivot