I'll get right back with you in about 1 hour. Need to go

Regards,
Howard

"Racingzeus" wrote in message
...
I have a spreadsheet with over 12000 enties in it on sheet 1 named Details.
There are 3 columns with data, col A PART NUMBER, col B PART DISCRIPTION
and
col C PRICE. I have added in a second sheet that I wish to use that if I
put
in the Part number in col A it will return the price in col B. In col B i
have used the following =VLOOKUP(A1,Details!A1:C12668,3,FALSE)
Using this formula whatever part number I enter in A1 I receive N/A in B1
even though that pert number exists. If I change the formula to
=VLOOKUP(A2,Details!A1:C12668,3,TRUE) I receive a price but it is
incorrect.
I have sorted sheet 1 Details into ascending order.
Please help me with this.

Many Thanks
Dave