|
|
#1
12-22-2011, 04:24 PM
|
|||
|
|||
Possible Lookup
I have 2 separate workbooks of data. The "new" one has 1000 rows of data. The "old" one has 750 rows of data. They both have the same exact columns. I need to look at the data in column "C" which is a unique part number. Match the old data with the new data. For example: If row 25 in the old one has part number 123 and row 35 in the new one has part number 123, I need to copy the entire row from the old to the new. I guess I can use a Lookup table, but I'm not sure how to tackle this.
So after matching the old with the new, there will be 250 rows that do not have data. HELP! I hope that I'm explaining this so it's understood. Any help is greatly appreciated 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 LookUp
|
aztiguen24 | Excel | 5 | 05-24-2011 03:57 AM |
| Multi-Variable Lookup help | ebolton | Excel | 8 | 05-05-2011 05:28 AM |
|
Field Lookup - Confused
|
lawnG | Word Tables | 1 | 01-31-2011 03:50 PM |
| Creating Lookup in Excel | vikash kumar | Excel | 2 | 12-06-2010 06:50 AM |
|
Using the LOOKUP Command
|
Grapejuice | Excel | 2 | 10-15-2008 02:02 PM |
Windows XP 
Office 2007
Threaded Mode