Howard,
I have took another look at the Part Numbers and there is a trailing space
at the end of every number. Is there any way I can remove thes ?

Dave

"Racingzeus" wrote:

Hi, The format for Part Number on both sheets are set to number and on the
summary sheet I am entering lots of part numbers and then auto sum to give me
an incoice total so the find feature would not be of any use.

Dave

"Farhad" wrote:

Well the thing i guess is that it may be the format of the partnumber in the
detail sheet is deffrent to the partnumber that you enter in the summary
sheet so if you just want to find one by one why you don't use Find feature
that Excel has?

Thanks,
--
Farhad Hodjat


"Racingzeus" wrote:

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