Alternative to Vlookup when dealing with two criterias?

[Jyggalag]

Hi all,

I currently have a large data set, it looks like this:

I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible.

The dates are correct in my other table, as well as the names, but I would like to find some nice way to get "Wealth" filled out.

Does anybody have any good formulas the might help with this? Would be greatly appreciated!

Thanks!

Jyggalag

 

[Alex Blakenburg]

Don't you just want SumIfs ?

Book4
	A	B	C	D					I	J	K	L
1	Name	Date	Wealth							Name	Date	Wealth
2	George	03-01-2020	1400							Kelly	03-01-2020	196
3	Kelly	03-01-2020	196							George	03-01-2020	1400
4	George	04-01-2020	1300							George	04-01-2020	2900
5	George	04-01-2020	1600							Bob	04-01-2020	2400
6	Bob	04-01-2020	2400
7
Sheet1

Cell Formulas
Range	Formula
L2:L5	L2	=SUMIFS($C$2:$C$6,$A$2:$A$6,J2,$B$2:$B$6,K2)

 

[Peter_SSs]

@Jyggalag
It is always a good idea to include your expected results with your sample data. In particular in this case it is unclear what results you want for the two rows that have George with 04-01-2020

 

[Jyggalag]

Don't you just want SumIfs ?

Book4
	A	B	C	D					I	J	K	L
1	Name	Date	Wealth							Name	Date	Wealth
2	George	03-01-2020	1400							Kelly	03-01-2020	196
3	Kelly	03-01-2020	196							George	03-01-2020	1400
4	George	04-01-2020	1300							George	04-01-2020	2900
5	George	04-01-2020	1600							Bob	04-01-2020	2400
6	Bob	04-01-2020	2400
7
Sheet1

Cell Formulas
Range	Formula
L2:L5	L2	=SUMIFS($C$2:$C$6,$A$2:$A$6,J2,$B$2:$B$6,K2)

Hi Alex,

SumIf is a nice formula, but I need to keep the values distinct unfortunately

 

[Jyggalag]

@Jyggalag
It is always a good idea to include your expected results with your sample data. In particular in this case it is unclear what results you want for the two rows that have George with 04-01-2020

Hi Peter,

Apologies if I was not coherent enough! I simply want to replicate the data in column A:C with a formula that pulls in wealth based on the values in column A and B, if that makes sense?

Naturally, since the name "George" appears twice with the same date, the formula should be able to ignore this and just insert the value at random, but make sure that both values for wealth are inserted (so both 1300 and 1600)

 

[Peter_SSs]

Could you please fill in your expected results manually and post the sample data again with the results you want?