Formula to compare two different data sets

Missed something, revised the formula

Fix it again

Azumi

Very awesome! I can't believe that you understood what I was trying to express and made a formula that does it! I am having one issue though, and I'm sure it goes back to my poor understanding of Excel scripting -- When I edit the formula to handle a list larger than 12 items, it simply repeats the first 12 items it searches for over and over again. Is there any way you can edit the formula to compensate a list of, say, 20,000 lines?

Thank you again, and I appreciate your help immensely.