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

Vlookup vs Index and Match in Excel by Chris Menard

Type in this information in Excel.<br>

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