Assemble a list of combinations/pairs into a matrix

Hi there,

I would like to assemble my data in a comparison matrix from a list of pairs. I feel I can do it with MATCH and VLOOKUP, but I am struggling a little bit.

My data is like this:

	A 	B	C
1	Label 1	Label 2	5
2	Label 1	Label 1	2
3	Label 3	Label 1	6
4	Label 2	Label 2	4
5	Label 2	Label 3	3

And I would like to get something like this:

	Label 1	Label 2	Label 3
Label 1	2		
Label 2	5	4	
Label 3	6	3

I don't particularly want to have a complete matrix at the end, but just correct values at the right intersections. I am struggling a bit because on a similarity matrix like this, the data is duplicated, but this is also the case with my list, in which I am not controlling whether I have "Label 1 x Label 2" or "Label 2 x Label 1". I don't care where to place the value on the matrix, but it's kind of confusing me.

Thanks a lot for your help and your advice, let me know if I can clarify more!

G.

One way is to use sumifs -- see highlighted cells in the attached.

Regards,
berlan

I didn't know about SUMIFS, it works perfectly, thank you very much!!

You're welcome