XLOOKUP Explained: Error handling, XLOOKUP with wild card and two-way XLOOKUP

#algrowchallenge #xlookup #lookup #exceltutorial #excel #exceltricks #excelformula #excelforbegginers #excelformulas #advancedexcel #advancedexceltraining #giveaway #giveaways

In this video I will cover following examples of XLOOKUP:

Error Handling - If the VLOOKUP function returns #NA, it is most likely because the item you are looking for does not exist in the lookup table. Wrapping the VLOOKUP function inside IFNA or IFERROR functions is the solution. However, with XLOOKUP, you no longer need to do so. Simply use the 4th argument of the XLOOKUP [If not found] optional argument to specify the value to return if the value does not exist on the lookup array.

XLOOKUP with wildcard: There may be times when you need to search for a partial match. In this case, you can combine wildcard characters like asterisk or question mark with the 5th argument of XLOOKUP, which is the optional [match mode] argument.

Two-way XLOOKUP: To look up a value on both the rows and columns, we can use XLOOKUP inside another XLOOKUP. The advantage is that we only need to be familiar with one function rather than combining multiple Excel lookup functions.

Check out these Playlists

Excel Lookup Functions:https://youtube.com/playlist?list=PLN5XHQr1r5K5Y6PcuQVPOVTba6iR2SNg7

Chart Tutorials: https://www.youtube.com/playlist?list=PLN5XHQr1r5K5f88YLMX_PQGb5ID-d4PKs

Excel Hacks: https://www.youtube.com/playlist?list=PLN5XHQr1r5K6rmS-8ywBDhfl0VaBufsmF

Excel Functions/Formulas: https://www.youtube.com/playlist?list=PLN5XHQr1r5K5GjdBPH7P6Hp-lYN9zdeSf

Excel Shorts: https://www.youtube.com/playlist?list=PLN5XHQr1r5K6oiBCR-eP4Ugd0OguRKEBx

Excel Data tab utilities: https://www.youtube.com/playlist?list=PLN5XHQr1r5K7HVcNUHrEaNPHWkdWQuaJe

Видео XLOOKUP Explained: Error handling, XLOOKUP with wild card and two-way XLOOKUP канала Excel with Ekta