How to Combine 2 Excel Workbooks Using VLOOKUP Function

VLOOKUP Function Arguments

VLOOKUP Function Arguments

I created this video tutorial to assist one of my viewers. He had 2 Excel Workbooks that he needed to combine. Because he had a MemberID Field in each workbook, I decided that the VLOOKUP() Function would be the fastest way to complete this task for my viewer.

Tips Covered in this Video

  • Move or Copy a Worksheet to another Excel Workbook
  • Use a Mixed Cell Reference – e.g. $A4 – so that column “A” reference is “frozen” when copying formula
  • Create “Named Range” to use as the “Table_Array” argument in VLOOKUP
  • Use FALSE as 4th (optional) argument in VLOOKUP to produce an “exact match”
  • Use IFERROR to prevent “error messages” from displaying

Watch this Video in High Definition

Click on this link to watch this Excel Tutorial  in High Definition on my YouTube Channel РDannyRocksExcels

Learn About My Training Resources

I invite you to visit my secure online shopping website – http://shop.thecompanyrocks.com – to learn about the many training resources that I offer for sale.

Watch Tutorial Now

 

 

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Comments

  1. This is wonderful. I was struggling with VLOOKUP. This vedo tutorial resolved the problem!!! I was able to accomplish my assignment easily. THANK YOU! You are the best!

  2. My pleasure! I am very happy that my Excel Tutorial helped you to resolve your problem.

    Thank you for your kind words!

    Danny Rocks
    The Company Rocks

  3. Can you not just lookup the other workbook with out copying the data to another workbook?

Speak Your Mind

*