VlookUp multiple same value ?

[excelNewbie22]

hi!
i'm trying to learn new function (for me),
how can i use vlookup to search all the values with the same name and return the sum of it all?
sample below

Excel-Practice-Data-for-Pivot-Table-1.xlsx
	B	C	D	E	F	G	H	I
4	Date	Client	Region	Month	Year	Quarter	Amount	230071
5	15-Jul-2019	ABC Corporation	South	July	2019	Q3	$1,741,089
6	19-Jul-2019	Bridges Company	East	July	2019	Q3	$514,989
7	26-Jul-2019	Timefall Inc.	East	July	2019	Q3	$230,071
8	11-Aug-2019	Chiral Corporation	North	August	2019	Q3	$1,148,912
9	15-Aug-2019	Titan Industries	West	August	2019	Q3	$405,991
10	22-Aug-2019	Eagle Security	South	August	2019	Q3	$191,708
11	24-Aug-2019	Sol Company	South	August	2019	Q3	$1,757,908
12	15-Sep-2019	Eagle Security	East	September	2019	Q3	$1,209,282
13	17-Sep-2019	Titan Industries	West	September	2019	Q3	$1,581,662
14	16-Oct-2019	Titan Industries	South	October	2019	Q4	$376,043
15	25-Oct-2019	Timefall Inc.	East	October	2019	Q4	$1,978,299
16	5-Nov-2019	Timefall Inc.	South	November	2019	Q4	$914,785
17	19-Nov-2019	Timefall Inc.	East	November	2019	Q4	$1,711,222
18	27-Nov-2019	Timefall Inc.	West	November	2019	Q4	$1,257,231
19	25-Nov-2019	Timefall Inc.	South	November	2019	Q4	$407,874
20	29-Nov-2019	Timefall Inc.	North	November	2019	Q4	$589,765
Problem

Cell Formulas
Range	Formula
I4	I4	=VLOOKUP(C15,C4:H30,6,FALSE)

 

[Sufiyan97]

I think you need SUMIF

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Date	Client	Region	Month	Year	Quarter	Amount			Lookup	Total
2	7/15/2019	ABC Corporation	South	July	2019	Q3	1741089			Timefall Inc.	7,089,247.00
3	7/19/2019	Bridges Company	East	July	2019	Q3	514989
4	7/26/2019	Timefall Inc.	East	July	2019	Q3	230071
5	8/11/2019	Chiral Corporation	North	August	2019	Q3	1148912
6	8/15/2019	Titan Industries	West	August	2019	Q3	405991
7	8/22/2019	Eagle Security	South	August	2019	Q3	191708
8	8/24/2019	Sol Company	South	August	2019	Q3	1757908
9	9/15/2019	Eagle Security	East	September	2019	Q3	1209282
10	9/17/2019	Titan Industries	West	September	2019	Q3	1581662
11	10/16/2019	Titan Industries	South	October	2019	Q4	376043
12	10/25/2019	Timefall Inc.	East	October	2019	Q4	1978299
13	11/5/2019	Timefall Inc.	South	November	2019	Q4	914785
14	11/19/2019	Timefall Inc.	East	November	2019	Q4	1711222
15	11/27/2019	Timefall Inc.	West	November	2019	Q4	1257231
16	11/25/2019	Timefall Inc.	South	November	2019	Q4	407874
17	11/29/2019	Timefall Inc.	North	November	2019	Q4	589765
18
19
Sheet7

Cell Formulas
Range	Formula
K2	K2	=SUMIF($B$2:$B$17,J2,$G$2:$G$17)

 

[Fluff]

how can i use vlookup to search all the values with the same name and return the sum of it all?

You can't but you need to use SUMIFS for that.

 

[excelNewbie22]

thanks Sufiyan97,
(also just watch mrexcel youtube video about sumifs)

and thank you Fluff for clarify that too!

 

[ExceLoki]

i'd use sumif

Book1
	B	C	D	E	F	G	H	I
1	Date	Client	Region	Month	Year	Quarter	Amount	7089247
2	43661	ABC Corporation	South	July	2019	Q3	1741089
3	43665	Bridges Company	East	July	2019	Q3	514989
4	43672	Timefall Inc.	East	July	2019	Q3	230071
5	43688	Chiral Corporation	North	August	2019	Q3	1148912
6	43692	Titan Industries	West	August	2019	Q3	405991
7	43699	Eagle Security	South	August	2019	Q3	191708
8	43701	Sol Company	South	August	2019	Q3	1757908
9	43723	Eagle Security	East	September	2019	Q3	1209282
10	43725	Titan Industries	West	September	2019	Q3	1581662
11	43754	Titan Industries	South	October	2019	Q4	376043
12	43763	Timefall Inc.	East	October	2019	Q4	1978299
13	43774	Timefall Inc.	South	November	2019	Q4	914785
14	43788	Timefall Inc.	East	November	2019	Q4	1711222
15	43796	Timefall Inc.	West	November	2019	Q4	1257231
16	43794	Timefall Inc.	South	November	2019	Q4	407874
17	43798	Timefall Inc.	North	November	2019	Q4	589765
Sheet1

Cell Formulas
Range	Formula
I1	I1	=SUMIF(C2:C17,C12,H2:H17)

 

[Sufiyan97]

You're welcome.
Glad we could help!