You need to lock the lookup array, ie either use Richard's
=ISNUMBER(MATCH(Wrksht2!A2,Wrksht1!$L:$L,0))

or, if for some reason the entire col L cannot be used,
and the lookup range is 'Wrksht1'!L2:L500
then put it in the top cell as:
=ISNUMBER(MATCH('Wrksht2'!A2,'Wrksht1'!$L$2:$L$500 ,0))
and copy down

The $ signs in: 'Wrksht1'!$L$2:$L$500
will ensure that the lookup range is locked when you copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Hinojosa via OfficeKB.com" wrote:
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...