Solved

Merge two excels - Using VLOOKUP to merge 2 Sheets

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
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!
This Experts Exchange lesson shows how to use VBA to loop through rows in Excel.  In order to sort, filter, and use database features, there needs to be a value in each column for every row. When data arrives with values missing, code to copy values…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…

786 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