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