Vlookup vs Index and Match in Excel

Posted on:  08/26/2017
Vlookup vs Index and Match in Excel

Vlookup is a great function. Most Excel users would have it in their top 10 function list. VLOOKUP is a lookup and reference function. If you are trying to find things in a table or a range by row Vlookup is a great function to use. Two other functions when joined together are better than Vlookup. They are the Index and Match function.

Just two reasons to use Index and Match over Vlookup in Excel:

  1. If you add or delete a column in your table, Vlookup will be wrong and Index and Match will still be correct.
  2. Vlookup can only look to the right. It can’t look to the left. Index and Match can look left and right.

Video on Vlookup vs. Index and Match

Type in this information in Excel.

Excel Data VLOOKUP

Type a county in F2 (the United States is shown) and the Index and Match function and Vlookup function.

VLOOKUP index match functions

 

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories