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
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
Category
📚
Learning