XLOOKUP Function | How to use Excel Xlookup (with 10 Examples) | What Xlookup Can Do for You?
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- XLOOKUP Function | How to use Excel Xlookup (with 10 Examples) | Discover what Xlookup can do for you.
Office 365 Playlist Link- • Office 365
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#xlookupfunction#excelxlookupformula #innozant #xlookupexplained #xlookuptutorial
![ฮักเทื่อสุดท้าย - บอย ศิริชัย [OFFICIAL MV]](http://i.ytimg.com/vi/-1PoPoQ-B-k/mqdefault.jpg)
Very interested xlookup function of excel 365 each point of xlookup function examples explain by you very nice thank you sir
Thanks Pramod ju❤️
Father of velookup.
Great vedio sir.
Thanks.
Thanks Tejpal ji
बहुत अच्छा लगा सर जी धन्यवाद् continues
Sir aap sa acha explain. koi bhe nhi krt hn sir pora youtub pa sir very nice
Thanks Aftab,apke itne valuable appreciation ke liye
Great video
Xlookup is excellent way of search but still I need to learn so much
👍❤️
Bahot accha formula h sir❤️
Sir bahut achha laga sikh ke.
Thanks ❤️
kya baat hai Guru ji ap to great ho
Mind-blowing. You are Super Super 🤩
Thanks ❤️
Lakhs of Thank You Sir For Explaining Superbly with Examples.
Thanks
HII SIR
This Function is very powerful
Great Guruji. I am very proud to be your student. Thank you Ji.
Love the way you explained and your ❤️
Thank you for explaining all possible usage options of the XLOOKUP function..
Will practice based on the file provided to download.
Ok.good❤️
Very well explained. Thanks a lot
Thanks Viswas❤️
Bahot shaandar tarike se saare features samjha diye aapne. Use karne ko toh pata nhi kab milega. Par sikh lena chahiye issliye sikh liya. Thank u sir
Thanks Vishal Ji❤️❤️
Excel-2007 मे Xlookup का add-in डालकर इसे थोड़ा-बहुत यूज़ करके देखा था, आपके वीडियो देखने के बाद इसमें और भी संभावनाएं दिख रही है।
धन्यवाद !.
Good❤️
Very Good Sir
This video was awesome 👍, learnt alot about this formula which I did not know earlier... thankyou
Thanks Vikas❤️
Bahut Khatarnak Samjhaye hai Mza agaya Jabardast
Thanks dear.Keep learning 👍❤️
Wonderful 😊 explanation of Xlookup sir I am learning from your videos a lot. In my office everyone is asking from where you are learning Microsoft Excel 😁😁😁😁. All credit goes to you sir 🤠🤠
Thanks dear ..keep learning
Very Interesting Sir, u are great Teacher. Thanks for teaching us in a simplified way. 🙏🙏🙏
Thanks dear.Keep Learning
Wow sir I am using ms office 365 but I was not aware for this magical function now I'll Use becouse of you really you are super sir nicely explain each and every things about xlookup.
Thanks dear..God bless You❤️
Xlookup is the King in 365
But, Vlookup is still the emperor for non 365 users like us😂😂😂
Dil se innozant ❤️
Thanks Vikash ji❤️
Excellent effort in explaining MS Excel in Hindi.
Thanks Sanjiv ji
Xlookup aapne to pehle bhi bataya hai abhi aapne jo explain kiya comparison ke sath awesome hai
Thanks Narender❤️
What function! Explained you have. "LOVE YOU SIR."🙏🙏🙏🙏🙏🙏
Thanks Pawan♥️👍
Thank you very much Sir...you are the real Guru
Thanks Sathya❤️
Good morning sir well explain👌👌
Thanks Satish ❤️
Thankyou so much sir it's very helpful
Thanks Geeta for your valuable appreciation..God bless You..Keep Learning ❤️
Thanks for explaining and learning to us for new function .
I seem that my work will be very easy to applying this function in routin work .Thanks to very much Sir
Thanks Suraj❤️
What are you doing?
Wow sir i was waiting for x-lookup function but aap sirf samjhate hi nhi hain.. Industrial use or industrial application k sath explain karte hain.. I know aapka vedio bht acha hoga thats why m vedio dekhne se pahle hi comment kar di 🙏
Thanks Aaradhana.Really means a lot to me dear ❤️👍
@@Innozant sir pls dashboard par ek complete series banayie, jaisa apne vlookup series banayi thi, that one was really very useful for the working employees
Sir bahut acha sir ji, thanks
Thanks Shivam❤️
Wonderful Function. Thanks. Now waiting for Power Bi Tutorial too
Thanks ❤️
Very great sir
Thanks ❤️
Thank Sir you explanation is always great...its makes very easy to understand the topic u r great sir...♥♥🙏🙏
Thanks Rajiv❤️
Thanks a lot sir.. So well explained and i started using this formula
Thanks Shankar ji
Thank you so much sirG for this amazing video
Thanks dear
Sir You are very good mentor. Your guidence so good. Aapsai bahut ummed hai sir ji. Take care sir & your health ❤
Thanks Sandeep ji❤️
Superb video ... mind blowing
Thanks ❤️
Sir super se upar wala video ❤
Very ifective formula😊
Dear Sir
Another superb usage of XLOOKUP function. I have learnt all parameters of XLOOKUP function from this video. I am very elated that you are going to upload videos on Power Bi. Hope you are well now.
Thanks & Regards
Jayanta Bhattacharyya
Thanks Jayanta ❤️
Excellent Sir , beautifully explained 👍👍
Thanks ❤️
Thank you so much sir
Thanks dear❤️
Thank you so much sir,
Thanks dear❤️
kya baat hai Guru ji
Thanks Amber
Superb video sir 🙏🙏😎😎
Thanks Rahul Ji
Awesome 🙏🏻🙏🏻🙏🏻
Thanks ❤️
Awesome sir🙏
❤️
Very nice video sir ji
❤❤
Amazing sir🙏🙏
❤️ thanks
Thanks
Informative. Thank-you
Thanks dear
excellent
No Match for innozant training thank you my dear Sir
Thanks Kishor❤️
Sir
Plz a video for the xlookup from different sheet also from other file
Thank you
Sir I have learned alot from your videos. The way you explain is simply superb. Sir ek chhota sa clarification chahiye, jab mai Xlookup mai return array de raha hoon and kuch column mujhe nahi chahiye to maine & use kar ke apna desired columns choose kar liye but enter karne per jo result show ho raha hai wo single cell mai hi show ho rahe hai ... alag alag cells mai nahi aa raha hai. Please suggest kaise karoon.
Aap use as standard function treat kar re ho
Thanks.
Hi sir data analyst skills required par video banaye please.
Ok dear❤️
Superb
Sir nice video sir xlookup pe or video upload kijiye advance level ke and good evening sir
Nyc video 👌
Thanks
Osm bro.
Maine aapki VBA ki video series dekhi bahut achchi hai par complete nahi hai aap se request hai ki VBA ki aur video banaye aur us series Ko poora kar do please
Jaroor ...keep learning
@@Innozant Thank you for replying and I am waiting for next VBA video............
Sir ye Xlookup series ka bohot hii sandar video hai,, but can we use Xlookup with indirect function? If yes plz make a video on this topic sir,, thank u sir dil se🥇♥️
Thanks dear..haan kisi video me karenge add dear
@@Innozant thank u sir,, bless us so that we can grow our career like u ,, thanks sir dil se
Sir I learned very much from you and impressed my boss too...got stuck in a problem in charts , I have a dynamic range of cells where some filled cells are blank on inserting chart it includes the blank cells and I don't want so plz guide
Kindly watch dashboard videos..
th-cam.com/video/PZWrLyXJR_E/w-d-xo.html
Great
Thanks Rajdeep Ji..Happy learning ❤️
Best
Osm video 😎😎😎😎😎
Thanks ❤️
great
Thanks sir
Sir power query ka video kab tak aayega please 🙏🙏🙏🙏
Kuch dinse tabiyatbsahi nhi hai isliye videos kam aa rhe hain may be next week se regular aayenge videos
How two fetch data from different workbooks in a single column by using xlookup for eg if the data is not found in work book 1 then find it on work book 2 if not in 2 then 3 ...
Nice video
Thanks ❤️
It was wonderful I understand every use of X lookup and know some new things like wildcard and two way search..Did you uploaded the same with Vlookup?
Vlookup complete series are there , Kindly find the playlist for the same ❤️
@@Innozant Thnk you so much😊
You great
Hello Sir, Point number 6 , Return Multiple value ... .. I have tried it between two different files .. but not work show #N/A ..
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
Sir excel ka kon sa version hai kyu ki mere pc me excel 2007 hai aur xlookup formula use karne par nahi ho raha hai
Sir I hope you are good, pls start uploading power BI videos ASAP... Thanks
Thanks..soon❤️
plz explain concept of next lower or higher.. plzzzzz
Sir🙏🙏🙏
Thanks ❤️
सर, मैंने आपकी विडियोज देखे और काफी कुछ सीखा भी है। कुछ नया करने के क्रम में थोड़ी रुकावट आई है, आप चाहे तो मेरी मदद कर सकते हैं।
कॉलम A में 1 से 5 row तक कुछ राशि लिखी है तथा 6 में उनका Total है। कॉलम B के 1 से 5 row में A अथवा P लिखना।
में चाहता हूं जिस row में A लिखूं उस row की कॉलम A की राशि Total से घट जाए।
Conditional formatting की तरह।
थान्याबाद।
Hi sir i have query can u solve its related to fuzxy xlookup
sir, multiple criteria me same to same formula type karne par bhi #N/A aa raha hai... kya reason hai?
💞👌🏼
Thanks ❤️
Hi in case of duplicate criteria in lookup table xlookup does not work, can u tell me how to use xlookup with combination of sum formula in this case
Sir power BI per video bnaaiye plz
Jald start kar rhe hain dear
sir jee xlookup multiple criteria mae we are using something different not following the commands!!. for example you used 1 for true.. plz explain
Sir column me same name repeat he or uske samne value he to muje repeat name ka total chahiye to kese hoga
For exp
Abc. 123
Xyz. 234
Abc. 456
Xyz 876
Masallah
Kya baat he
❤️❤️
Dear sir,
kindly share limitations of this function also if any.
#innozant
In multiple criteria why start with 1 as a lookup value
Hello sir ,
mera data me se xlookup data nikal nahi parahahai xlookup with multiple criteria
Respected sir how ?I use this function in excel 2007 please tell
This is office 365 functions..dear
sir we can do all the things which can done by vlookup, mostly vlookup is used and u also used vlookup many times in video but why XLOOKUP not used
is any reason not to use XLOOKUp
pl make a video on XLOOKUP to get multiple results/records not multiple conditions.thank yu
Ok.dear.❤️
How to use xlookup with different workbook?
👍👍👍👍👍👍
Thanks ❤️