| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare worksheets for duplicates and copy data to 1st worksheet
I have two worksheets. One with 1000 rows of part numbers (SHEET1) and the
other with 16000 rows of part numbers (SHEET 2). I would like to compare the sheets. If "SHEET 2" has a matching part number in "SHEET 1"; then copy the data in "SHEET 2" - columns B, C & D for that matching part number to "SHEET 1" columns E, F & G. In other words add the information to the end of that row. I can use VLookup, but end up with bunches of #N/A's that I would have to delete. Is there a better way? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare worksheets for duplicates and copy data to 1st worksheet
You can still use VLookup just include an error test.
=if(iserror(vlookup("your arguments here")),"",vlookup("Same formula as earlier")) Instead of showing an error this will show nothing. -- JNW "Monique" wrote: I have two worksheets. One with 1000 rows of part numbers (SHEET1) and the other with 16000 rows of part numbers (SHEET 2). I would like to compare the sheets. If "SHEET 2" has a matching part number in "SHEET 1"; then copy the data in "SHEET 2" - columns B, C & D for that matching part number to "SHEET 1" columns E, F & G. In other words add the information to the end of that row. I can use VLookup, but end up with bunches of #N/A's that I would have to delete. Is there a better way? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare worksheets for duplicates and copy data to 1st workshe
Thanks. I also now understand the "iserror" test!
Monique "JNW" wrote: You can still use VLookup just include an error test. =if(iserror(vlookup("your arguments here")),"",vlookup("Same formula as earlier")) Instead of showing an error this will show nothing. -- JNW "Monique" wrote: I have two worksheets. One with 1000 rows of part numbers (SHEET1) and the other with 16000 rows of part numbers (SHEET 2). I would like to compare the sheets. If "SHEET 2" has a matching part number in "SHEET 1"; then copy the data in "SHEET 2" - columns B, C & D for that matching part number to "SHEET 1" columns E, F & G. In other words add the information to the end of that row. I can use VLookup, but end up with bunches of #N/A's that I would have to delete. Is there a better way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare a value and if is true copy the line to other worksheet | Excel Worksheet Functions | |||
| compare two columns within a worksheet, then highlight duplicates | Excel Worksheet Functions | |||
| I need to compare two worksheets and create a new worksheet | Excel Discussion (Misc queries) | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
| compare worksheets data | Excel Discussion (Misc queries) | |||
Linear Mode
