VLOOKUP driving me out of my skull!!!

[Belly Flopper]

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

 

[Dave Peterson]

There's a difference between the text '123 and the value 123.

And =vlookup()'s match is sensitive to that.

Debra Dalgleish has some troubleshooting tips at:
http://contextures.com/xlFunctions02.html#Trouble