0:32 - VERTICAL lookup example
2:21 - HORIZONTAL lookup example

Learn how to use the XLOOKUP function which is the next generation lookup function in Microsoft Excel. The XLOOKUP function has the functionality of both the VLOOKUP as well as the HLOOKUP functions, without the limitations.

This tutorial demonstrates how to use Excel XLOOKUP with our easy to follow examples and takes you through how to perform a vertical lookup as well as a horizontal lookup.

XLOOKUP Function (and sample data):
https://www.techonthenet.com/excel/formulas/xlookup.php

How to use the VLOOKUP function in Excel:
https://youtu.be/ODZfwD39gGE
https://www.techonthenet.com/excel/formulas/vlookup.php

How to use the HLOOKUP function in Excel:
https://youtu.be/rNlie4RGdCU
https://www.techonthenet.com/excel/formulas/hlookup.php

Excel Functions/Formulas:
https://www.techonthenet.com/excel/formulas/index.php

Excel Tutorials:
https://www.techonthenet.com/excel/index.php

Don't forget to subscribe to our channel for more great Excel tutorials!

Visit us at: https://www.techonthenet.com
or follow us on:

Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthenetcom/