The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel
Learn how the new Excel XLOOKUP function can replace VLOOKUP & INDEX MATCH. Partial match, reverse order, and horizontal lookup formulas are now possible with this one function.
XLOOKUP can perform both vertical or horizontal lookups to return a value from a matching row or column. The function only requires 3 arguments and separates the lookup and return arranges for lookup formulas that are easier to read and write.
Read the full article and download the Excel file: https://www.excelcampus.com/functions/xlookup-explained/
Here is the agenda for the video.
1. Overview of XLOOKUP. How to write the formula and an explanation of all 5 arguments. 0:56
2. Horizontal lookups 4:16
3. Partial Match with Wildcard Characters 4:56
4. Reverse Search Order 6:54
5. A brief preview of XMATCH 7:47
6. XLOOKUP vs. VLOOKUP 8:12
7. XLOOKUP to the Left 10:04
8. XLOOKUP Closest/Approximate Match 10:33
9. XLOOKUP vs INDEX MATCH 11:30
10. Pros or Advantages of XLOOKUP 13:01
11. Cons or Drawbacks of XLOOKUP 13:48
12. # VALUE! Error with XLOOKUP 14:20
13. VLOOKUP Assistant preview 16:02
14. Availability & Compatibility 18:48
15. Questions for you 19:49
Please leave a comment below and answer either or both of the following questions:
1. What do you think of XLOOKUP?
2. What other uses or problems are you wondering if XLOOKUP can solve?
Additional Resources:
To get XLOOKUP you will need to have an Office 365 subscription and be on the Insiders Fast Channel using Excel for Windows or Mac. Here is a link to join the free Office Insiders program. https://insider.office.com/
Download the Excel file I use in the video: https://www.excelcampus.com/filedownload/functions-formulas/XLOOKUP-Explained.xlsx
Note: You will need a version of Excel that supports XLOOKUP for the formulas to work.
Download the VLOOKUP Assistant Tool: https://www.excelcampus.com/functions/vlookup-assistant-preview/
Video about VLOOKUP Assistant: https://www.youtube.com/watch?v=g2_Yu_VRQ9E
Thank you! 🙂
#ExcelCampus #MsExcel
Видео The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel канала Excel Campus - Jon
XLOOKUP can perform both vertical or horizontal lookups to return a value from a matching row or column. The function only requires 3 arguments and separates the lookup and return arranges for lookup formulas that are easier to read and write.
Read the full article and download the Excel file: https://www.excelcampus.com/functions/xlookup-explained/
Here is the agenda for the video.
1. Overview of XLOOKUP. How to write the formula and an explanation of all 5 arguments. 0:56
2. Horizontal lookups 4:16
3. Partial Match with Wildcard Characters 4:56
4. Reverse Search Order 6:54
5. A brief preview of XMATCH 7:47
6. XLOOKUP vs. VLOOKUP 8:12
7. XLOOKUP to the Left 10:04
8. XLOOKUP Closest/Approximate Match 10:33
9. XLOOKUP vs INDEX MATCH 11:30
10. Pros or Advantages of XLOOKUP 13:01
11. Cons or Drawbacks of XLOOKUP 13:48
12. # VALUE! Error with XLOOKUP 14:20
13. VLOOKUP Assistant preview 16:02
14. Availability & Compatibility 18:48
15. Questions for you 19:49
Please leave a comment below and answer either or both of the following questions:
1. What do you think of XLOOKUP?
2. What other uses or problems are you wondering if XLOOKUP can solve?
Additional Resources:
To get XLOOKUP you will need to have an Office 365 subscription and be on the Insiders Fast Channel using Excel for Windows or Mac. Here is a link to join the free Office Insiders program. https://insider.office.com/
Download the Excel file I use in the video: https://www.excelcampus.com/filedownload/functions-formulas/XLOOKUP-Explained.xlsx
Note: You will need a version of Excel that supports XLOOKUP for the formulas to work.
Download the VLOOKUP Assistant Tool: https://www.excelcampus.com/functions/vlookup-assistant-preview/
Video about VLOOKUP Assistant: https://www.youtube.com/watch?v=g2_Yu_VRQ9E
Thank you! 🙂
#ExcelCampus #MsExcel
Видео The New XLOOKUP Function: Compared to VLOOKUP & INDEX MATCH in Excel канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
INDEX MATCH Explained (An Alternative to VLOOKUP)VLOOKUP Tutorial for Excel - Everything You Need To Know50 Ultimate Excel Tips and Tricks for 2020Power Query Overview - Automate Data Tasks in Excel & Power BI7 Uncommon Excel Shortcuts to Teach to Your CoworkersIntroduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Dashboard - Plan vs Actual Variances - FREE DownloadExcel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, KeyboardsCreate Multiple Dependent Drop-Down Lists in Excel (on Every Row)Searchable Drop Down List in Excel (Very Easy with FILTER Function)Excel XLOOKUP Function Definitive GuideExcel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600☑️ Top 30 Advanced Excel Tips and TricksExcel shortcut keys you SHOULD know!Return Multiple Match Results in Excel (2 methods)Excel 2016 Advanced☑️ Top 25 Advanced Pivot Table Tips & Tricks For Microsoft ExcelVlookup simply explained6 New Functions In Excel 2019 You Need To Learn10 Excel XLOOKUP Function Examples (Better than VLOOKUP & INDEX/MATCH)