VLOOKUP driving me out of my skull!!!

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

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

Belly Flopper wrote:
>
> 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