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.
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.
Asked in February 2016
Viewed 3,302 times
Answered 1 times
Leave an answer
Quote of the day: live life