Xlookup In Excel Excel Tutorials For Beginners

Sign up for our Excel webinar, times added weekly: excelcampus.com/blueprint-registration/
In this video, I give a brief overview of the new XLOOKUP function in Excel, an alternative to VLOOKUP or INDEX MATCH.

Here are some of the major features of XLOOKUP that I share in the video:

1. Only 3 Required Arguments
2. Exact Match by Default
3. Separate Lookup & Return Ranges
4. Vertical OR Horizontal Lookup
5. Partial Match with Wildcards
6. Reverse Search Order
7. Cause of # VALUE! Error
8. Availability & Compatibility

The XLOOKUP function searches for the lookup value in a column/row and returns a value from an adjacent row/column where the match is found.

It has options for exact match, closest match, and partial match with wildcard characters. It can also search in reverse order.

Additional Resources:

Full In-Depth Tutorial on XLOOKUP: youtu.be/pURSha68Mjs

Blog post on XLOOKUP: excelcampus.com/functions/xlookup-explained/

VLOOKUP Tutorial: youtu.be/d3BYVQ6xIE4

VLOOKUP Assistant Preview: youtu.be/g2_Yu_VRQ9E

Please leave a comment below with any questions or suggestions. Thank you! 🙂

#ExcelCampus #MsExcel
00:00 Introduction
00:50 XLOOKUP
01:58 Search Order

Author

Ariyani

Como educador, estou profundamente engajado no desenvolvimento dos estudantes em ambiente escolar, adotando métodos pedagógicos que valorizam conexões genuínas e são movidos por inovação e fervor. É minha vocação guiar os alunos na jornada de se tornarem uma geração notável, empregando estratégias de ensino amplamente aclamadas por prestigiadas instituições acadêmicas ao redor do globo - preview.pbjmanagement.co.uk