By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 904 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

EXCEL VLOOKUP and FULL OUTER JOIN

P: 15
HI,

I need help with excel VLOOKUP! I am at a new job and really trying to solve this without asking anyone at work, since they seem th expect me to know this. What I am trying to acheive is the same thing as a FULL OUTER JOIN if you are familiar with sql. I tried to do this is in access, but access does not support full joins.

Anyhow: I have two email lists, one woth 2500 entries, one with 2600. They are located in same worksheet, one in column A, one in column B. Some emails match, some do not. I want to have the two lists side-by-side in a workheet, with the matching emails next to each other, and also gaps for non-mathcing emails. If I do VLOOKUP I want the missing emails in both columns. I am not at all familiar with VLOOKUP and do not even know where to begin! I appreciate any advise.
May 6 '07 #1
Share this Question
Share on Google+
5 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
HI,

I need help with excel VLOOKUP! I am at a new job and really trying to solve this without asking anyone at work, since they seem th expect me to know this. What I am trying to acheive is the same thing as a FULL OUTER JOIN if you are familiar with sql. I tried to do this is in access, but access does not support full joins.

Anyhow: I have two email lists, one woth 2500 entries, one with 2600. They are located in same worksheet, one in column A, one in column B. Some emails match, some do not. I want to have the two lists side-by-side in a workheet, with the matching emails next to each other, and also gaps for non-mathcing emails. If I do VLOOKUP I want the missing emails in both columns. I am not at all familiar with VLOOKUP and do not even know where to begin! I appreciate any advise.
You can use a UNION query to achieve the results you need in Access.
Expand|Select|Wrap|Line Numbers
  1. SELECT Table1.email, Table2.email
  2. FROM Table1 LEFT JOIN Table2
  3. ON Table1.email = Table2.email
  4. UNION
  5. SELECT Table1.email, Table2.email
  6. FROM Table2 LEFT JOIN Table1
  7. ON Table2.email = Table1.email
  8.  
May 7 '07 #2

P: 15
You can use a UNION query to achieve the results you need in Access.
Expand|Select|Wrap|Line Numbers
  1. SELECT Table1.email, Table2.email
  2. FROM Table1 LEFT JOIN Table2
  3. ON Table1.email = Table2.email
  4. UNION
  5. SELECT Table1.email, Table2.email
  6. FROM Table2 LEFT JOIN Table1
  7. ON Table2.email = Table1.email
  8.  
Hi!

Thanks a million! It worked! That is great!
May 7 '07 #3

P: 15
It does work, but one thing, I think the second join is supposed to be RIGHT?

Thanks!
May 7 '07 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
It does work, but one thing, I think the second join is supposed to be RIGHT?

Thanks!
You're welcome.

If you make the second join a right join you'll have to reverse the tables.
May 7 '07 #5

P: 15
Thanks! It gives me what I want!
May 7 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.