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:

Please Login or Register  to view this content.

And I would like to get something like this:

Please Login or Register  to view this content.

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