But the problem is i do want a perfect match.
I have 2 lists:
Product Exception
01238451 01238451
01323472 01355763
01355763
02545364
02454776

The product list is greater than the exceptions list. I want to use the
match formula, to show me where the exceptions are, then i can delete
them (made easier by using the filter). I do not know why the match
formal does not work for all of the exceptions, it does for some.


--
cj21
------------------------------------------------------------------------
cj21's Profile: http://www.excelforum.com/member.php...o&userid=25673
View this thread: http://www.excelforum.com/showthread...hreadid=509910