Try this alongside 123 on sheet1, assuming 123 is in cell A2
=IF(COUNTIF(Sheet2!A:A,A2)0,"Y","")
and fill down the column (assuming your second sheet is called Sheet2 and
your range of numbers is in column A)

Andy.

"JR573PUTT" wrote
in message ...

These Formulas Only Reference A Single List, And Do Not Seem To Apply To
My Problem. I Am Comparing 2 Separate List, Let Me Know If You Don't
Understand My Problem, I Will Restate It.


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=520749