Hi Dave,

It is possible the part numbers look alike but one may have a leading or
trailing space. In an empty cell enter =A1=Details!A1 to test for True or
False. Where the A1 cells of each sheet are a pair of troublesome lookups.
You will get a True or False, and I suspect yours will return False. If so
adjust as needed to clean up the part numbers of the troubled sheet.

Also, you may want to try this with 'clean' part numbers on both sheets.

Select two cells in a row where you want your lookup values to appear, (the
description and the price). While still selected type in this formula:

=VLOOKUP(D1,A1:C5,{2,3},0)

Now hit Ctrl + Shift + Enter, you should get { } brackets around the
formulas and you description will be in first cell and the price in the
second. Of course adjust the cell address's to suit your sheet. And your
list does not need to be sorted when using the FALSE or 0 as the fourth
argument.

HTH
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