Combing 2 Lists into 1

[Keyboardist]

I know this is a simple task, but I'm having trouble.

I need to combine A & B with C & D into E & F without duplicates.

Below is what I'm trying to do

A	B	C	D	E	F
AMN	2.09	APH	16	AMN	2.09
APH	11.08	DG	14	APH	27.08
ENDO	28.75	GTC	17	ENDO	28.75
FRAM	20.05	HSH	7	FRAM	20.05
LDO	6.10	LDO	23	LDO	29.10

<tbody>
</tbody>

I am continually changing A-D, so the formula in E & F needs to update with that.

 

[DRSteele]

I'm not certain I understand your objective, but I think this is what you're after. Both formulas will work.

	A	B	C	D	E	F	G
1	AMN	2.09	APH	16	AMN	2.09	2.09
2	APH	11.08	DG	14	APH	27.08	27.08
3	ENDO	28.75	GTC	17	ENDO	28.75	28.75
4	FRAM	20.05	HSH	7	FRAM	20.05	20.05
5	LDO	6.1	LDO	23	LDO	29.1	29.1

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet15​

Worksheet Formulas Cell Formula F1 =SUMPRODUCT((E1=$A$1:$A$5)*$B$1:$B$5)+SUMPRODUCT((E1=$C$1:$C$5)*$D$1:$D$5) G1 =SUMIFS($B$1:$B$5,$A$1:$A$5,E1)+SUMIFS($D$1:$D$5,$C$1:$C$5,E1) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[Keyboardist]

Worksheet Formulas Cell Formula F1 =SUMPRODUCT((E1=$A$1:$A$5)*$B$1:$B$5)+SUMPRODUCT((E1=$C$1:$C$5)*$D$1:$D$5) G1 =SUMIFS($B$1:$B$5,$A$1:$A$5,E1)+SUMIFS($D$1:$D$5,$C$1:$C$5,E1) <tbody> </tbody>

<tbody>
</tbody>

That is exactly what I was attempting to do. Thank you.

 

[DRSteele]

You're welcome. I'm glad your project is moving forward.