Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Excel - merge 2 sheets using a common column


(!)

memphiszen's Avatar
memphiszen memphiszen is offline
Computer Specs
Member with 62 posts.
THREAD STARTER
 
Join Date: Aug 2007
Experience: Intermediate
14-Aug-2008, 10:52 AM #1
Excel - merge 2 sheets using a common column
Hi all - I need to take 2 different worksheets that have different data, but have one column in common (for ex - serial #) and merge the two in a new worksheet. Any ideas how to do this easily?
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
14-Aug-2008, 01:00 PM #2
You will want to look into the Vlookup function. It allows you to lookup and match a field and display data from the corresponding row.
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
15-Aug-2008, 12:27 AM #3
Quote:
Originally Posted by memphiszen View Post
Hi all - I need to take 2 different worksheets that have different data, but have one column in common (for ex - serial #) and merge the two in a new worksheet. Any ideas how to do this easily?
Like Jimr said it can be done using Vlookup function, also it can be done by a macro!

On both sheets for one particular serial # you have only one se of data, or you can have multiple instances of the same serial # (or what ever is the the same for both sheets)?
memphiszen's Avatar
memphiszen memphiszen is offline
Computer Specs
Member with 62 posts.
THREAD STARTER
 
Join Date: Aug 2007
Experience: Intermediate
15-Aug-2008, 08:52 AM #4
Macros
Thanks for the replies. I've used VLOOKUP before, but it's been a few years. The macro idea sounds possible. Using my example, there would be one sheet, Sheet1, with Serial #, and multiple other columns of data, let's say color, weight, other features. Sheet2 would have the serial# column as well, but the rest of the columns are different, example price, tax, and others. I need to merge the two into one sheet, combining all columns other than serial #. The serial # just needs to appear once on the new sheet. Does this help? Thanks.
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
15-Aug-2008, 08:59 AM #5
You did not said if one serial is only once on both sheets?
If so it's easy, but if not then tell us on which sheet it can be found more that once!
jimr381's Avatar
Computer Specs
Member with 4,175 posts.
 
Join Date: Jul 2007
Location: Vienna, VA
Experience: Computer Illiterate
15-Aug-2008, 09:19 AM #6
If it matches up in a one to one relationship you would want to just do multiple Vlookups. There is no reason to do a macro if you do not have to. I am trying to follow the KISS philosophy here.
Aj_old's Avatar
Aj_old Aj_old is offline
Computer Specs
Senior Member with 869 posts.
 
Join Date: Sep 2007
Location: Moldova
Experience: Intermediate
15-Aug-2008, 10:19 AM #7
Please upload an example sheet with some dummy data
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2