Скачать с ютуб How to use the XLOOKUP function in Excel в хорошем качестве

How to use the XLOOKUP function in Excel

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