How do I join two worksheets in Excel as I would in SQL?
Posted
by
Joel Coehoorn
on Super User
See other posts from Super User
or by Joel Coehoorn
Published on 2012-05-04T16:20:11Z
Indexed on
2013/10/26
22:02 UTC
Read the original article
Hit count: 238
microsoft-excel
I have two worksheets in two different Excel files. They both contain a list of names and addresses. One is a master list that includes other fields, and the other is a list that only includes name and address and an id column that was pared down by another office.
I want to use the 2nd list to filter the first. I know how I could do this very easily with a database inner join, but I'm less clear on how to do this efficiently in Excel. How can join two worksheets in Excel? Bonus points for showing how to do outer joins as well, and I would greatly prefer konwing how to do this without needing a macro.
© Super User or respective owner