Why is XLOOKUP cool? How does it work? How does it help in Excel Esports tasks?

You can use the XLOOKUP function to find things in a table or range by row. Andrew Ngai, the winner of the recent Excel Esports All-Star Battle AND FMWC Open 2021, explains it all in this video.

To watch the full battle and see Andrew in action, go to: https://youtu.be/x1RVNGDSdw4

Download Modelario case (loads of training for XLOOKUP): https://www.fmworldcup.com/product/modelario-all-star-battle-2022/

Learn more about XLOOKUP: https://support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

0:00 How does XLOOKUP work?
01:00 Why is XLOOKUP cool?
02:23 XLOOKUP spotted in All-Star Battle
------------------------------------------------------
Learn more about us: https://www.fmworldcup.com/

For more updates, follow us on social media:
LinkedIn: https://www.linkedin.com/company/financial-modeling-world-cup/
Facebook: https://www.facebook.com/financialmodelingworldcup
Twitter: https://twitter.com/FMWC_
Reddit: https://www.reddit.com/r/FMWC/