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.

<colgroup><col width="64" span="5" style="width:48pt"></colgroup><tbody>
</tbody>

Name1	Value1	Name2	Value2
A	1	A	1
B	2	C
C	3	F
D	4
E	5
F	6

<tbody>
</tbody>

 

[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