BH537TP
asked on
Excel 2010 Merge of two tables
Hello,
1. We have data in two worksheets inside one workbook
2. There are numerous columns/rows in each
3. Trying to find a value in one and then merge the rows from worksheet 2 based on if we could match the value
Any help on formulas would be great!
1. We have data in two worksheets inside one workbook
2. There are numerous columns/rows in each
3. Trying to find a value in one and then merge the rows from worksheet 2 based on if we could match the value
Any help on formulas would be great!
Your request is quite nebulous , however, from what you have said, you need to use a VLOOKUP in worksheet 1 to find matching columns in worksheet 2. If you can give some examples then some specific formulas can be provided.
ASKER
Thanks for your response, Anthony. Yes, I can use a VLOOKUP to see if a the same value exist in worksheet 1. If the value exist, I would like to take that entire row and associated columns and move it /append to the row in worksheet two without overwriting the data.
For example: I want to see if Value1 in worksheet 1 is also located in worksheet 2. Worksheet 2 has 5 columns. If the value is found the formula would take the row and the 5 columns and move it to worksheet 1 where the original value was located.
Hope that helps to clarify??
For example: I want to see if Value1 in worksheet 1 is also located in worksheet 2. Worksheet 2 has 5 columns. If the value is found the formula would take the row and the 5 columns and move it to worksheet 1 where the original value was located.
Hope that helps to clarify??
Please upload a sample workbook with the layout as same as your original workbook.
Populate two sheets with few rows of dummy data and on sheet3, mock up the desired output manually and rename it as Desired Output.
That will help us to know about the layout of both the sheets and the desired output you are trying to achieve or steps you are trying to automate.
Populate two sheets with few rows of dummy data and on sheet3, mock up the desired output manually and rename it as Desired Output.
That will help us to know about the layout of both the sheets and the desired output you are trying to achieve or steps you are trying to automate.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.