How to use the XLOOKUP function in Excel

Опубликовано: 19 Ноябрь 2024
на канале: TechOnTheNet

246,049

1.5k

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/fo...

How to use the VLOOKUP function in Excel:
   • How to use the VLOOKUP function in Excel
https://www.techonthenet.com/excel/fo...

How to use the HLOOKUP function in Excel:
   • How to use the HLOOKUP function in Excel
https://www.techonthenet.com/excel/fo...

Excel Functions/Formulas:
https://www.techonthenet.com/excel/fo...

Excel Tutorials:
https://www.techonthenet.com/excel/in...

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:   / techonthenetcom
Twitter:   / tech_on_the_net
Pinterest:   / techonthenetcom