The first list has 2,500 part-numbers; the second list has 1 million
part-numbers.

How can I move the part-numbers in the first list so they are next to
the matching part-numbers in the second list?

On Oct 8, 6:49 pm, gary wrote:
The first list has 2,500 part-numbers; the second list has 1 million
part-numbers.

How can I move the part-numbers in the first list so they are next to
the matching part-numbers in the second list?

Don't have 2007 (yet), but couldn't you just use a VLOOKUP formula to
get it's match? Or am I oversimplifying the issue?

On Oct 8, 4:47 pm, JW wrote:
On Oct 8, 6:49 pm, gary wrote:

The first list has 2,500 part-numbers; the second list has 1 million
part-numbers.

How can I move the part-numbers in the first list so they are next to
the matching part-numbers in the second list?

Don't have 2007 (yet), but couldn't you just use a VLOOKUP formula to
get it's match? Or am I oversimplifying the issue?


Using my example (col A has 2500 cells, col B has 1 million cells),
how should the VLOOKUP formula be written to find exact matches?

Quite frankly, I would use Access (database) for this task.
Name the large (1 million part numbers) file Master.
Name the smaller (2,500 part numbers) file PartNumber.
Import each into its own table by the same name.
Then build a query to join the 2 tables together.

SELECT Master.PartNumber, PartNumbers.PartNumber
FROM Master LEFT JOIN PartNumbers ON Master.PartNumber =
PartNumbers.PartNumber;

--
Regards,
Bill Renaud

(Made a typo. Corrected below.)

Quite frankly, I would use Access (database) for this task.
Name the large (1 million part numbers) file Master.
Name the smaller (2,500 part numbers) file PartNumbers (<=correction here).
Import each into its own table by the same name, with the data in a field
named PartNumber.
Then build a query to join the 2 tables together.

SELECT Master.PartNumber, PartNumbers.PartNumber
FROM Master LEFT JOIN PartNumbers ON Master.PartNumber =
PartNumbers.PartNumber;

--
Regards,
Bill Renaud

Bill, I agree whole heartedly that, with data of this size, Access is
certainly the best answer.
To the OP, if you absolutely have to keep this in Excel, your VLOOKUP
would look like this:
In C2, place this:
=VLOOKUP(B2,A:A,1,FALSE)

Copy down as needed. Just remember, you are dealing with an enormous
amount of data, so this might take quite a while to calculate
completely. That is why I agree with Bill in saying that Access is
the best solution.
Bill Renaud wrote:
(Made a typo. Corrected below.)

Quite frankly, I would use Access (database) for this task.
Name the large (1 million part numbers) file Master.
Name the smaller (2,500 part numbers) file PartNumbers (<=correction here).
Import each into its own table by the same name, with the data in a field
named PartNumber.
Then build a query to join the 2 tables together.

SELECT Master.PartNumber, PartNumbers.PartNumber
FROM Master LEFT JOIN PartNumbers ON Master.PartNumber =
PartNumbers.PartNumber;

--
Regards,
Bill Renaud