Could people see my matching problem posted before. I have don an
example to show my problem. It is attached.

Thanks for the help


+-------------------------------------------------------------------+
|Filename: Book1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4330 |
+-------------------------------------------------------------------+

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

Not sure what you're trying to do but I noticed that your formulae are
offset by 1...meaning that the formula in B2 is trying to match A1 the
formula in B3 A2 and so on. If your trying to get rid of the #N/A then
use:

=IF(ISNA(MATCH(A2,$C$2:$C$7,0)),"",MATCH(A2,$C$2:$ C$7,0))

HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=509910

You are right i have made an error there-it should be A2 as opposed to
A1.

However, for my real data set the match does not work-for some values,
even though the format is correct. I can't work out why. On an exactly
the same data set it works. Unfortunately the file is too big to post.

Chris


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

The way your formula is set up it will only return a value for an exact
match.

try:

=MATCH(A2,$C$2:$C$7,1)

HTH
Jean-Guy


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=509910

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

I think i've found where the problem lies. My product list is 5000 rows,
the first 700 product codes begin with a zero, thus the product column
and the exceptions column are both formatted as text.

The match formula works for the first 700 rows (products beginning with
a 0) and then stops- i don't know why? I have tried changing the format
but that does not work.


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