Hi all - hoping for a little advise!!

I have a sheet that I use to list damaged product in a column. In the
next column I have a VLOOKUP formula that refers to another sheet in
the same workbook, that will look up the price of the defective item
and record it in the second column.

I can not seem to get it to work. The product number is entered
exactly ... but nothing... however if I cut and past the product
number from the price sheet it works fine!! retype it and I get #N/A
- cut and past - it works!!!

The formula I have is =VLOOKUP(D11,PRICESHEET!$A$1:$S$3922,19,FALSE)

The product code is entered into D11; the PRICESHEET range is correct
..... everything works if I cut & paste the product number from
PRICESHEET ...

TIA

Mike