XLOOKUP

Part I: Goodbye VLOOKUP. Hello XLOOKUP! Learn how to use this brand new function for Excel. No more counting columns! Show your coworkers how to do “LEFT-LOOKUPS” the easy way.

Part II: See ya HLOOKUP (not that we used it much anyways). XLOOKUP has us covered!

Part III: See how XLOOKUP’s unique “search mode” argument allows you to choose between starting at the top of a list, or at the bottom, when you search for a lookup value — XLOOKUP’s secret weapon!