How to Lookup a Value Using Multiple Columns in Excel

There are times when the VLOOKUP Function will not return the value that you want to lookup. Suppose, for example, that you need to lookup the “Title” for an employee where the First Name and Last Name are in separate columns. A VLOOKUP() will not help you in this example. Let me show you how to accomplish this.

Key Concepts Covered

  • Use the “&” (Ampersand) to Join two cells that contain Text Values
  • Use the Index() and Match() Functions for the Lookup
  • Create an Array Formula to perform the Lookup – Use “Ctrl+Shift+Enter” with Array Formulas
  • Create and use “Named Cell Ranges” in your formulas to make it easier to enter and understand the formula

Be sure to check out all of the other Excel Video Lessons on Lookups. Click here to go to the Archive of Lookup Function Videos.

I invite you to subscribe to my “Danny Rocks Tips and Timesavers”Video Podcast on iTunes – it is free!

You can learn how to “Master Excel in Minutes!”

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

Speak Your Mind