Home Ask Login Register

Developers Planet

Your answer is one click away!

AndrewDps February 2016

Excel - Comparison of four columns

I need to compare four columns like the ones in the image.

If A+B contents are identical to C+D, in the E I want to see the correct REF number (1st Column).

If those are not identical, I want to show N/A or something similar.

[Image Link](http://imageshack.com/a/img921/3108/cKWoNT.png)

What solution do you suggest?


Scott Craner February 2016

Try this Array formula:

=MATCH(C1 & D1,$A$1:$A$4 & $B$1:$B$4,0)

It must be confirmed with Ctrl-Shift-Enter instead of Enter to exit edit mode.

![enter image description here

Post Status

Asked in February 2016
Viewed 3,302 times
Voted 8
Answered 1 times


Leave an answer

Quote of the day: live life