How to learn XLOOKUP with the help of 6 AMAZING examples
How to learn XLOOKUP with the help of 6 AMAZING examples: This video explains how to use XLOOKUP function, in detail with 6 examples. This is a new lookup functions introduced in Excel 365, It is a powerful yet easy to use tool. This fucntions will replace VLOOKUP & HLOOKUP.
How to use XLOOKUP in Excel: These functions let us search for a value in both left and right direction and return the corresponding value from another column or range.
This function handles a very common error condition of VLOOKUP & HLOOKUP.
Visit & Subscribe channel:
/ @techreflections
This video is part of excel course and it contains:
Working of XLOOKUP with the help of 6 examples touching all aspects of the function.
This video lecture is part of the video series on Excel and it tools.
Welcome to Tech Reflections (#techreflections) & I am Vikram.
Leave a comment on this video and let me know if you used this function across multiple sheets and did you face any issues.
If you need to know more about the Excel formulas & functions then checkout the below playlist
• Excel - Formulae & Functions
Checkout Other Playlists on this channel:
Conditional Formatting:
• Excel - Conditional Formatting
Pivot Tables:
• Pivot Tables & its features
#techreflections #xlookup #vlookupkiller