How to Combine 2 Excel Workbooks Using VLOOKUP
This is a request from one of my viewers. In his organization, two people were working on this project and he needed to produce a consolidated Excel worksheet.
Fortunately, when I look at the workbooks he sent me, I noticed that both had a MemberID field that contained the Unique Account Numbers. With this knowledge, I decided that the VLOOKUP Function would be the easiest way to complete this task.
Here is a list of the Excel Techniques that I demonstrate in this tutorial:
Move or Copy a worksheet to another Excel Workbook
Create a Named Range to use as the "Table_array" in the VLOOKUP Function
Use "Mixed Cell References" - e.g. $A4 - in VLOOKUP Function
Use FALSE as the optional 4th Argument in VLOOKUP to produce an "Exact Match"
Use IFERROR Function to prevent Error Messages from appearing
I invite you to visit my secure online shopping website - http://shop.thecompanyrocks.com - to examine the many training resources that I offer for sale.
Danny Rocks
The Company Rocks
Watch video How to Combine 2 Excel Workbooks Using VLOOKUP online without registration, duration hours minute second in high quality. This video was added by user Danny Rocks 13 August 2012, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,473,681 once and liked it 4.4 thousand people.