One thing that often happens with numeric Part numbers is that some are text
and the others are numeric. What you tell it to be has little to do with
what it actually is.
The other things I would watch out for is if there is a formula which
generates the part number. A sort on an active equation can change the part
number so that it is different after the sort than befor.
In your lookup table did you use false as the last entry in the lookup
formula?
if you use false you will not have to sort to be able use the lookup formula.
Note the text,number issue can still raise its ugly head. Lookup tabes do
not recognise a text 12 to be the same as a numeric 12.

"Methodman1" wrote:


Hi all,

I have been given a task to find out information for a list of part
numbers. The information can be found in another Excel table that I
have, which is quite large (~25,000 rows). Since I'm working with a
large number of part numbers, I'm trying to extract the information
from the larger table so that I can use it to complete the new
"smaller" table (~900 rows).

I've tried to add the part numbers from the small table into the
existing larger table, and then resort, however I'm running into
problems. For some reason the part numbers are not sorting correctly.
It seems that there are almost 2 sorts happening. I've checked the cell
formats and everything is the same, so I'm confused as to why I can't
get the column to sort correctly. If I get it to sort the right way,
I'll use an "IF" statement to find the matches in the part numbers then
I will just filter out the "YES" matches.

Any help that could be provided would be greatly appreciated. If my
explanation of the problem can't be understood, please let me know (I
would be surprised if it is hard to follow).

Thanks in advance!


--
Methodman1
------------------------------------------------------------------------
Methodman1's Profile: http://www.excelforum.com/member.php...o&userid=24246
View this thread: http://www.excelforum.com/showthread...hreadid=378528