Solved

Merge two excels - Using VLOOKUP to merge 2 Sheets

Posted on 2014-09-19
2
235 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
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 end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

757 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now