Just to clarify (I'm not sure I explained it very good)

Imagine two sheets

Sheet #1 <-(Seibel converted to xls) Sheet #2 (xls sheet to be
worked on)
12345 54986 (mark as NO
MATCH)
84596 25746 (mark as NO
MATCH)
24578 12345 (mark as
MATCH!)
96328 15789 (mark as NO
MATCH)
45897 96328 (mark as
MATCH!)

The problem is Sheet #2 is not only five rows, it is like 30000+ rows,
and I
will have to do another 30000+ rows soon, so 60000+ to do by hand is
very slow indeed.

Also, 95% of all the rows in Sheet #2 will be a NO MATCH with no
matching zip codes to ANY of the zip codes of Sheet #1. So less than 5%
will actually be a match, but the thing is I have to check ALL of them
to actually know which ones match and which don't.

IS there a utility / macro or function in Excel that can quickly let me
do this the automated way?

Thanks


--
bxc2739
------------------------------------------------------------------------
bxc2739's Profile: http://www.excelforum.com/member.php...o&userid=32538
View this thread: http://www.excelforum.com/showthread...hreadid=534995