I have a list of 176 items and another list of 870 items.  I need to
see if the items in the smaller list are on the bigger list.  There is
no guarentee of any ascending or descending sort order.  And I need to
match two values in the same row.

So:
IF (A2 is in B2:B871) _
   AND **in the same row** C2 matches the value in col D _
   THEN return "Yes"

MATCH and LOOKUP seem to require a sort order.  And I'm not sure how
to use the row number with those.  I could cobble together a macro,
but I thought a built-in function might be faster and easier (not to
mention I might actually learn something!).

Any help is greatly appreciated.
Ed