What Xlookup Can Do For You ? Xlookup Tutorial - Xlookup in Excel in Hindi
in this video you will learn Excel New XLOOKUP formula. No more VLOOKUP. The NEW Excel XLOOKUP Function is here to to solve your lookup problems #xlookup #deepakeduworld
What is XLOOKUP?
If you need to lookup a value on another Excel sheet or table, you can use the XLOOKUP function. Here are some of its features:
- XLOOKUP can lookup values to the left OR right-hand side of the lookup range.
- XLOOKUP looks for an exact match by default (you can change it if you like)
- XLOOKUP can look for the next smallest value or the next largest value (approximate or close match)
- XLOOKUP can do vertical AND horizontal lookups
- XLOOKUP can find the first match or the last match (reverse lookup)
- XLOOKUP can return sum of multiple columns
- XLOOKUP can lookup for multiple lookup values without helper column
so in this video i have explained xlookup function in detail. hope you will enjoy this video.
Subscribe DEEPAK TECHWORLD : [ Ссылка ]
Download Training File : [ Ссылка ]
Subscribe and Become Family Mamber of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
[ Ссылка ]
ADVANCED EXCEL ►
[ Ссылка ]
ADVANCED EXCEL FORMULAS ►
[ Ссылка ]
EXCEL TIPS & TRICKS ►
[ Ссылка ]
MS WORD ►
[ Ссылка ]
HTML5 & CSS3 ►
[ Ссылка ]
COMPUTER TECHNICAL videos ►
[ Ссылка ]
AUTOMATIC INVOICE IN EXCEL ►
[ Ссылка ]
PHOTOSHOP ►
[ Ссылка ]
Subscribe Deepak EduWorld ► [ Ссылка ]
Instagram ► [ Ссылка ]
Facebook page ► [ Ссылка ]
LinkedIn ► [ Ссылка ]
Facebook Group ► [ Ссылка ]
We Always Provide Useful & Helpful Content On The Deepak Eduworld Youtube Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
Tags : deepak eduworld,xlookup,excel xlookup,xlookup vs vlookup,xlookup explained,xlookup in excel,xlookup function,vlookup,xlookup formula,xlookup vs vlookup excel,xlookup between sheets,what is xlookup,office 365,xlookup tutorial,vlookup in excel,nested xlookup,xlookup in excel in hindi,xlookup formula in excel,excel online course,excel functions,vlookup vs xlookup,excel formulas and functions,hindi
