VLOOKUP to the left in Excel Learn how to use VLOOKUP to retrieve data to the left in Excel. Discover two methods - INDEX and MATCH, and the improved XLOOKUP function.