Xlookup function in Excel|How to use Xlookup function #xlookup

 

In this tutorial I have explained Xlookup function function from the very basic level to an advance level in one video. Xlookup function is very advanced function which has just been released in Microsoft 365. it can perform jobs which were done by vlookup function hlookup function and many more. it has three mandatory Syntax arguments and three optional arguments which can be used pull out the data from a very complex a data sheet in your time. the parts of the video have been timestamped so you can go to the description of this video or the first comment to look for the specific part of a video. Timestamps: Introduction to Xlookup function: 0:10 Difference between Vlookup and Xlookup: 0:50 Custom text for error: 4:01 Left to right use of Xlookup: 5:12 Xlookup for searching entire table: 6:15 Match Mode: 8:35 Search mode: 11:25 Xlookup function as two way Vlookup Function: 15:09 Xlookup function as multiple lookup function function: 17:35