use lakshmid said:
How to compare two columns in excel sheet with other two columns and mark them as "yes" or "no"
I want formula to do this below scenario
List 1 = Column A + Column B + Column C+ Column D
List 2 = Column F + Column G
Orange, Navel , 3, 4
Orange, Navel , 3, 4 no