What formula is required to find and add values from a matching data set?

[TravelMI]

Hi,

I was hoping someone could advise what formula can be used for my query?

If I have a full list of unique data in Columns A & B, is there a formula I can use to match up Column A & C and then add the Value1 to the corresponding Value2 field?


The first line is an example where by Value2 is added as it uses Value1 from the first two Columns.
[TABLE="width: 320"]
<colgroup><col width="64" span="5" style="width:48pt"></colgroup><tbody>[TR]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"]

[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl65, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name1[/TD]
[TD]Value1[/TD]
[TD]Name2[/TD]
[TD]Value2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]1[/TD]
[TD]A[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]2[/TD]
[TD]C[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]3[/TD]
[TD]F[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Fluff]

How about

Excel 2013/2016
	A	B	C	D
1	Name1	Value1	Name2	Value2
2	A	1	A	1
3	B	2	C	3
4	C	3	F	6
5	D	4
6	E	5
7	F	6
List

Cell Formulas
Range	Formula
D2	=INDEX(A$2:B$7,MATCH(C2,A$2:A$7,0),2)

 

[TravelMI]

Yes, that works perfectly.

Thank you very much. This will save me a lot of time!

 

[Fluff]

Glad to help & thanks for the feedback