"Casino Guy" wrote:
.. Could you possibly create an example ..

One play assuming I've read your underlying intent correctly ..

Assume col A contains the "master" list of numbers, and col B contains
another list to be checked against the master, data from row1 down, e.g.:

500 385
385 124
489 562
829 489
419 829
etc etc

Put in C1:
= IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),ROW(),"") )

Put in D1:
= IF(B1="","",IF(ISNUMBER(MATCH(B1,A:A,0)),"",ROW()) )

Put in E1:
=IF(ISERROR(SMALL(C:C,ROWS($A$1:A1))),"",
INDEX($B:$B,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0)) )

Copy E1 across to F1

Then just select C1:F1 and copy down
until the last row of data in col B

Col E returns all the numbers in col B found in col A
Col F returns all the numbers in col B not found in col A

(Results will be nicely bunched at the top in cols E & F)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--