Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help with Two Table Merging
I have posted this question before and maybe need to add more info. I hope someone can help me here. I have a workbook with two worksheets (I will call them worksheet1 and worksheet2), from worksheet1 I need to test the values of two dfferent columns with the values of two different columns in worksheet2. When both batches are true - I want to copy the value of another column, same row as the match from worksheet1 to worksheet2. Each worksheet contains about 300 records, each column has a title (fieldname). I have given each data table a range name. Below is my logic, I just don't know how to write in excel: If value in column 1 of worksheet1 = value in column 1 of worksheet2 and value of column 2 of worksheet1 = value in column 2 of worksheet2, then copy the content of column 3 (same row) from worksheet1 to worksheet2. Please, please, can someone tell me how to do this and possibly write the code and explain each part of said written ode for my understanding. Thanks so much!! Winston -- wingale ------------------------------------------------------------------------ wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467 View this thread: http://www.excelforum.com/showthread...hreadid=533144 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please Help with Two Table Merging
In Worksheet2, cell C2:
=SUMPRODUCT((Worksheet1:A$2:A$300=A2)*(Worksheet1! B$2:B$300=B2);C$2:C$300) then copy down HTH -- AP "wingale" a écrit dans le message de ... I have posted this question before and maybe need to add more info. I hope someone can help me here. I have a workbook with two worksheets (I will call them worksheet1 and worksheet2), from worksheet1 I need to test the values of two dfferent columns with the values of two different columns in worksheet2. When both batches are true - I want to copy the value of another column, same row as the match from worksheet1 to worksheet2. Each worksheet contains about 300 records, each column has a title (fieldname). I have given each data table a range name. Below is my logic, I just don't know how to write in excel: If value in column 1 of worksheet1 = value in column 1 of worksheet2 and value of column 2 of worksheet1 = value in column 2 of worksheet2, then copy the content of column 3 (same row) from worksheet1 to worksheet2. Please, please, can someone tell me how to do this and possibly write the code and explain each part of said written ode for my understanding. Thanks so much!! Winston -- wingale ------------------------------------------------------------------------ wingale's Profile: http://www.excelforum.com/member.php...o&userid=33467 View this thread: http://www.excelforum.com/showthread...hreadid=533144 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging documents,exporting long landscape table to word with page breaks & numbers | Excel Discussion (Misc queries) | |||
Merging Workbook Table data Based upon Value comparisons | New Users to Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Merging Pivot Table Data | Excel Discussion (Misc queries) | |||
Merging info from a table to a report | Excel Discussion (Misc queries) |