Excel Forum

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
Lookup Functions in Excel
INDEX() Function
MATCH() Function
Why Vlookup isn't always the best lookup function to use in Excel
Search a Table using an inside column not on the left of the table.
   Difficulty:         Intermediate
   Video:               Yes

Got a Question? Ask it Here in the Forum.