VLOOKUP inquiry

[Duley]

I'm using the formula IF(B1=VLOOKUP(B1,A$1:A$5000,1,FALSE),"DUPLICATE"," ").

Problem is: on the first worksheet, in the workbook, the formula works as I expect it to. When I use the formula in the second worksheet the lookup function will not return an answer when the text in the B column is typed in, It will only work if the text is copied and pasted in!

I've tried new worksheets and workbooks but it still will not work unless the text is copied to the B column.

I'm using EXCEL 2000.

Thanks

[mother earth]

hi,

maybe you can try this formula in the C column (where the sheet name is incorparated)
=IF(B1=VLOOKUP(B1,Sheet1!$A$1:$A$5000,1,FALSE),"DUPLICATE"," ")

[Duley]

Wow, now it's works! Thank you Mother Earth for the Rx. I've learned something today.

Duley