How to Use Index/Match Instead of Vlookup (Excel)
Using Vlookup is a great tool, however, if you add columns to your original table of data, you will have to create a new Vlookup formula. If you use Index/Match, you can add or remove columns without having to create a new formula. We are actually using two separate functions together, Index and Match can also be used separately.