|
Featured Tutorial
Featured Macro
Excel Lookup/Search Tip 1 - Using Index and Match - It's Better than Vlookup
Learn how to use the Index and Match lookup functions in Microsoft Excel. They are better to use than the Vlookup function; in fact, never use the Vlookup function again (unless truly needed). The index and match functions allow you to search any column in a table and return data from any column in a table and therefore eliminates the restriction imposed by Vlookup that the lookup value must always be in the leftmost column of the table. This is a great set of excel functions and formulas to learn. It will save you a lot of time when searching your excel spreadsheets.
Topics Covered
![]() ![]() ![]() ![]() ![]()
Difficulty: Intermediate
Video: Yes |