yogi_Compare Two Columns In A Sheet With Two Other Columns And Mark As 'yes' Or 'no'

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
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

There are two lists.
List 1 = Column A + Column B + Column C+ Column D
List 2 = Column F + Column G

List 1

Orange, Cara Cara , 1, 2
Orange, Navel     , 3, 4

Orange, Blood     , 7, 8
List 2

Orange, Cara Cara
Orange, Blood

Now, I want columns A &B to be compared to F &G and post "yes" of the value is present in list 2 and "no" if its not present in column D.

Output

Orange, Cara Cara , 1, 2  yes
Orange, Navel     , 3, 4   no

Orange, Blood     , 7, 8  yes

Please let me know ASAP.

Thanks

------------------------------------

following is one solution to the problem