How to Do a reverse-order VLOOKUP with Excel's INDEX & MATCH
New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 319th installment in their series of digital spreadsheet magic tricks, you'll learn how to run a VLOOKUP in reverse order using the INDEX & MATCH functions and custom number formatting.