Home |
Search |
Today's Posts |
#1
|
|||
|
|||
comare and copy
Hello,
I have two worksheets(1, 2). There are two columns (item code, description) in the two worksheets. I want to compare the item codes in the worksheet1 and worksheet2 then if the item codes are same in two worksheets, copy the description from worksheet1 to worksheet2 automatically. How can I do it ? Thank you! Best regards, -- George |
#2
|
|||
|
|||
See Vlookup in excel help.
Regards Rowan "smb2000user100" wrote: Hello, I have two worksheets(1, 2). There are two columns (item code, description) in the two worksheets. I want to compare the item codes in the worksheet1 and worksheet2 then if the item codes are same in two worksheets, copy the description from worksheet1 to worksheet2 automatically. How can I do it ? Thank you! Best regards, -- George |
#3
|
|||
|
|||
Let's assume your item codes are in column A on both worksheets, and you have
descriptions in column B in the 1st worksheet only. In the 2nd worksheet, column B, put this formula =VLOOKUP(A2,Sheet1!$A$2:$B$1000,2,0) and copy it down. That assumes you have 1000 rows filled on Sheet1. Adjust the references to suit. To convert those formula to their values, Edit/Copy the column of formulas, then, without changing the selection, Edit/Paste Special and select the Values option. On Thu, 21 Apr 2005 13:08:06 -0700, "smb2000user100" wrote: Hello, I have two worksheets(1, 2). There are two columns (item code, description) in the two worksheets. I want to compare the item codes in the worksheet1 and worksheet2 then if the item codes are same in two worksheets, copy the description from worksheet1 to worksheet2 automatically. How can I do it ? Thank you! Best regards, |
#4
|
|||
|
|||
It works. Thank you very much!
"Myrna Larson" wrote: Let's assume your item codes are in column A on both worksheets, and you have descriptions in column B in the 1st worksheet only. In the 2nd worksheet, column B, put this formula =VLOOKUP(A2,Sheet1!$A$2:$B$1000,2,0) and copy it down. That assumes you have 1000 rows filled on Sheet1. Adjust the references to suit. To convert those formula to their values, Edit/Copy the column of formulas, then, without changing the selection, Edit/Paste Special and select the Values option. On Thu, 21 Apr 2005 13:08:06 -0700, "smb2000user100" wrote: Hello, I have two worksheets(1, 2). There are two columns (item code, description) in the two worksheets. I want to compare the item codes in the worksheet1 and worksheet2 then if the item codes are same in two worksheets, copy the description from worksheet1 to worksheet2 automatically. How can I do it ? Thank you! Best regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|