How do I join two worksheets in Excel as I would in SQL?
- by Joel Coehoorn
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…