Merge two excels - Using VLOOKUP to merge 2 Sheets

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 ?
Who is Participating?
johnb25Connect With a Mentor Commented:

Paste this into row 2  of whichever column in Sheet1 you want the Logon information to appear, and copy down 650 rows:
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 ("").

paologiorgioAuthor Commented:
I have also just discovered the power of FLASHFILL in Excel 2013.....WOW !!!!!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.