Comparing items in lists

Hey guys, I've used Excel a lot in the past but over the past year haven't used it much. I'm trying to accomplish something, and am either just drawing a blank on how to do it or it is just not possible. What I'm trying to do actually seems pretty simple, it's basically this:

I want to be able to enter in a short list of some items, like say:
Oranges | Apples | Pears | Mangoes

and then I want to be able to see which of the following lists have one or more of the same items in the list above:
Oranges | Apples | Pears | Bananas
Grapes | Apples | Pears | Bananas
Grapes | Nectarines | Bananas | Kiwi
and so on....

So, in other words, I'm looking for a method to return an answer that would tell me that the first list has 3 of the same items, the second list has 2, the third has none, so I can compare at-a-glance

The only way I can think to do this is with prohibitively large number of of IF and OR functions

Thanks in advance to anyone that could help. I think it's really cool that this forum exists to ask neat Excel questions

The formulas would be considerably affected by your layout. Can you mock up these lists as you plan to use them and then mockup the desired results from the sample data so we can see what your goal is visually.

Click GO ADVANCED and use the paperclip icon to post up your workbook.