The example is wrong, so it's best ignored. In column A i have a list of
products which are 8-digits long, the first 500 of which start with a 0.
In column E i have a list of product codes that i want matched.

The match formula matches the products beginning with 0, but ignores
the rest.

Chris


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