Check out the attachment. Why does the match formula not work( for
product 777)? The columns Exception and code are both formatted as text
because of the zero. I need them to stay formatted as text.

Any ideas

Chris


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

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