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
