How To: Do a reverse-order VLOOKUP with Excel's INDEX & MATCH

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.

Have an iPhone? Check out all 200+ new features coming in iOS 13.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest