Excel Formula on : How to compare multiple columns in excel I am trying to compare multiple columns in excel like below

A          B          C          D         E            F
HN_1     1.1.1.1     Comp_1    HN_1     1.1.1.1       Comp_1
HN_2     2.2.2.2     Comp_1    HN_2     3.3.3.3       Comp_2
HN_3     3.3.3.3     Comp_2    HN_3       N/A         Comp_3
HN_4     4.4.4.4     Comp_3    
HN_5     3.3.3.3     Comp_2    HN_4     4.4.4.4       Comp_3


a. Compare A &amp; D (if true return "Same Name Only")

b. IF A = D then compare B = E (return "Same Name, IP ") 

c. IF A = D &amp;&amp; B = E then compare C = F  (return "Same Name, IP, Comp")
I'll do the first one, then you can use and() to sort the other two:

=IF(A1=D1,"Same Name Only","")


Hint:

AND(A1+D1,B1+E1)


Well, see