Solved

Merge two excels - Using VLOOKUP to merge 2 Sheets

Posted on 2014-09-19
2
245 Views
Last Modified: 2014-10-03
I have two excel sheets with common column called UPN. One sheet has 650 rows and the other has 600.  Sheet2 (600) only has two columns Column A - UPN and Column B - Last Logon Date. Sheet 1 has 10 columns with various headings. I want to insert column B from Sheet 2 into Sheet 1 corresponding to matching UPN.  I know VLOOKUP is my friend here, but still confused as to how to do this. Any simple explanations to assist me ?
0
Comment
Question by:paologiorgio
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 6

Accepted Solution

by:
johnb25 earned 500 total points
ID: 40332174
Hi,

Paste this into row 2  of whichever column in Sheet1 you want the Logon information to appear, and copy down 650 rows:
=IFERROR(VLOOKUP(A2,Sheet2!A:B,2,0),"")
It assumes the UPN reference in sheet1 is in Col A, and starting from row 2.
Where there is no match it leaves the cell blank ("").

John
0
 

Author Closing Comment

by:paologiorgio
ID: 40359064
I have also just discovered the power of FLASHFILL in Excel 2013.....WOW !!!!!
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
how to add IIS SMTP to handle application/Scanner relays into office 365.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question