How to Use New Excel Function XLOOKUP

Hello everyone. Now #VLOOKUP is no more, because VLOOKUP replaced by #XLOOKUP(). Yes now we have to stay with new and improved more powerful function XLOOKUP, because, its do the job of #LOOKUP, #HLOOKUP, #VLOOKUP, #INDEXMATCH.

This function is a modern and replacement of VLOOKUP, HLOOKUP, and LOOKUP. XLOOKUP supports exact and approximate match, wildcards for partial matches, and lookups in vertical or horizontal and also lookup in reverse ranges.

Watch this video to know more in detail

How to Get Free Office 365
https://youtu.be/reIFHO5UDnQ


Also Watch New Functions of Excel.
#XLOOKUP :- https://youtu.be/15ziUhOp-3M
#XMATCH :- https://youtu.be/w8pWKjMyLgA
#XMATCH :- https://youtu.be/OI9RDF9jFm4
#SORTBY :- https://youtu.be/Ojm5Xaff5hE
#SORT :- https://youtu.be/Bnw943d1Fpw
#UNIQUE :- https://youtu.be/N4k5_hiB9fA
#FILTER :- https://youtu.be/9u9ncDUfmpE

Subscribe YouTube & Follow on Dailymotion
https://www.YouTube.com/c/exceluniverse
https://www.dailymotion.com/exceluniverse

Download practice file here
https://mega.nz/file/x350XJIa#IsRxiz76VtzCWv1NpqSOv_li1ot9hk0lJP58llJ-fLs