Good Morning

I'm trying to create a formula that will compare one cell to another column
on a different page.

Lets say i have the PO A999-9999 on Wrksht 2 I want to compare this to column
L on Wrksht 1 and if it finds a match say true.

I have tried =L2='Worksheet1'!L2:L2456
also =L2='Worksheet1'!L:L

It just keeps saying false and there are a couple that I know is true... so
can anyone help me out with this asap? thanks!!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...links/200612/1