Sign up for our Excel webinar, times added weekly: [ Ссылка ]
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: [ Ссылка ]

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. [ Ссылка ]

Download the Excel file I use in the video: [ Ссылка ]
Note: You will need a version of Excel that supports XLOOKUP for the formulas to work.

Download the VLOOKUP Assistant Tool: [ Ссылка ]

Video about VLOOKUP Assistant: [ Ссылка ]

Thank you! 🙂

#ExcelCampus #MsExcel
00:00 Introduction
00:16 The New XLOOKUP
04:18 Horizontal Lookup
04:56 Partial Match with Wildcards
06:54 Search Order
08:13 XLOOKUP vs. VLOOKUP
10:34 Closest Match
11:31 XLOOKUP vs. INDEX MATCH
13:02 Pros & Cons of XLOOKUP
18:48 Availability & Compatibility

свернуть