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.