Solved

Merge two excels - Using VLOOKUP to merge 2 Sheets

Posted on 2014-09-19
2
251 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

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

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

Check out this step-by-step guide for using the newly updated Experts Exchange mobile app—released on May 30.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…

628 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