XLOOKUP vs VLOOKUP in Excel ( Practice file also )

Practice file Link :-

https://www.mediafire.com/file/p5q6oa2o177gvh1/XLokkkup.rar/file

• XLOOKUP searches for data both horizontally and vertically. VLOOKUP searches only vertically.
• XLOOKUP can refer to the left of the lookup value. It always looks up the values towards the right of the lookup value.
• XLOOKUP can look for values to the left and right of the lookup array, while VLOOKUP is limited to only looking for values to the right of the lookup value column.
• XLOOKUP function is convenient to use. It allows you to input a custom error text message
• XLOOKUP allows you to perform a better approximate match and return the next larger or smaller values from your lookup table as well.
• XLOOKUP Intakes an Optional Argument to Use Wildcard Characters.