I tried that and it's doing the same thing that it was doing with mine
let say we have have to copy it down 500 times it will do this

=ISNUMBER(MATCH('Wrksht2'!A2,'Wrksht1'!$L2:$L500,0 ))
=ISNUMBER(MATCH('Wrksht2'!A3,'Wrksht1'!$L3:$L501,0 ))
=ISNUMBER(MATCH('Wrksht2'!A4,'Wrksht1'!$L4:$L502,0 ))
=ISNUMBER(MATCH('Wrksht2'!A5,'Wrksht1'!$L5:$L503,0 ))

And so on...


RichardSchollar wrote:
OK assuming your data on Wrksht2 is in column A (adjust as appropriate)
then on Wrksht 2 you'd use a formula like:

=ISNUMBER(MATCH(Wrksht2!A2,Wrksht1!$L:$L,0))

which will return True if the exact number is also on Wrksht1 col L or
False if it isn't.

Hope this helps!

Richard

Good Morning

[quoted text clipped - 13 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200612/1

--
Message posted via http://www.officekb.com