How To Apply VLOOKUP and XLOOKUP formula on Large / Big Data in Excel (Hindi)
ฝัง
- เผยแพร่เมื่อ 28 ส.ค. 2024
- vlookup and xlookup are most useful and powerful formulas in microsoft excel, in this excel tutorial i will show you, How To Apply VLOOKUP and XLOOKUP formula on Large / Big Data in Excel (Hindi) #vlookup #xlookup #excel
Download Training File : bit.ly/44g0K8Y
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP TUTORIALS ►
bit.ly/3kJyIBv
Thanks for Watching
Deepak EduWorld
Related Searches : vlookup in excel,vlookup formula,vlookup in hindi,how to use vlookup in excel,vlookup function,deepak eduworld,vlookup in excel in hindi,excel formulas and functions,vlookup formula in excel,vlookup formula in excel in hindi,xlookup,xlookup formula,xlookup formula in excel,xlookup in excel,vlookup,excel,excel vlookup,ms excel,excel for beginners,xlookup function,xlookup in excel in hindi,vlookup on large data,xlookup on large data'
Dosto kaisa laga video 😊
Gazab, excellent 👌👌
Sir ye filter se bhi ho jaayega jaldi ,Jo aapne sikhaya thha
Sir Maine aapse ek question Kiya thha sir aapka reply nhi aaya filter formulas se related
THUMBS UP 👍🏻 VELI VELI LEMONI, GABAR 😎 KA ASLI PASAND
You are best the teacher
Depak sir everything is fine but ap jo b likhen English ma please hindi mijhy ni ati jis wajha sy mujhy kuch chezen samjh ni ati ur link ya information comment specially
@@nileshkathe5916 Niles ap ko kesy pta ya recorded video ha
I love watching your excell tricks. They really are worthy of investing time on. I am a big fan of your presentation too.
Very well explained,
You are top class,
Made is simple and explained the functions.
Amazing Baiya 👏
Always ki traah....super se bhi upar ....100 💯% excellent Excel work
Dear Sir
I regularly watch your videos, and learn a lot from you.
Thank you very much, stay blessed.
Shahid from Pakistan.
Bhai aapki video kaafi ache hoti hai & jitni aasani se aap smjhaate ho wo kaafi taarife kaabil hai .
God bless you brother.
Awesome teaching skills .
Bhut saara pyaar aapko ❤❤
And definitely I add like,comment,subscribe also 😅
Different types of formula by u is interesting. Thank u Sir
Dear, i m requesting you to kindly prepare a video of Inventory for 26 items, with daily sales opening and closing balance, 3 salesman's are selling all the daily sales of 3 salesman's with shop name also included.
Thanks and Regards...
Lots of Love and Respect from Pakistan (Because you are my Teacher).
Thanks again
Amazing learning Method, watching from Bangladesh 🇧🇩
Useful information sir
Aap apne videos ko ko si category me upload krte h education ya science & technology
Agr education h to usme sub category me kya choose krte h
Education
Bahot acha sir😊
Thank you I learn something new today.
Even I shared with my friends.
Thank you ❤️ your video made my concepts clear
I like your last style topic 👍😁
Thank you aapse sikhne ko mila, i am very happy today.
I have one question, while applying either vlook up or Xlookup at one instance its throwing error, this could be a nice case for troubleshooting? would you mind connection on the same?
Thanks a lot for the video.
Sir apka video se bohot benifit hua but ek question tha, how to use vlookup or hlookup or xlookup or any formula, if whole data in already filtered
Great ,,, excellent
👍❤❤❤❤❤❤❤❤
Thank you for great information
Very nice sir
Awesome deepak
Very nice sir 🎉🥳🎉
Very useful
Great boss.....sweet and simple with short time and clarity
Buhut acha Laga sir
U r completely saver for us when it comes to excel
Very nice.
Sir...xlookup download kayese kare dikha dijiye..pls
Ek No🙏
One step ahead ❤
Excellent sir
Very helpful ....super
right from pakistan
Mind blowing 😊😊😊😊
Thankyou sir
Sir baki Sara clear hai bas ye batiye ki agar multiple colum me se different select kese kare result me for example a b c d e f g h me b d f h .
Separate video jaldi aayega… is topic par ✅
Ok
good enformation
Love you bro nice app achy sy gaide krty Hain thanks
Video to accha hai sir. Ek part reh gya. Isko drag down kaise karenge?
I think JB drag down krty Han to formula bilkul thk Kam krta h but JB hum left to right drag krty to issue hota is ly column freeze kr lain gy
Accha laga sir
THANK U SOO MUCH ITS A GREAT
This video was like a lightbulb turning on in my head. So informative and easy to learn and deploy.
Sir mind blowing
Thanku u so much
really v good, informative, easy to understand, video. loved it. thanks
thank u
Very helpful sir for comparing large data
Super
Ek nambar sir
Gajab 👏👏👏👌
Very helpful video sir
Awesome 👍
THANKYOU WOULD BE A SMALL WORD FOR THIS KNOWLEDGE WHICH YOU HAS PRIVIDED HERE . . . .. . . . BUT " THANKYOU "
Sir, please teach us how to find full record of such a large data from columns into rows throgh vlookup.. Like DMC etc.
Wao nice vedio
Sir apka course hai kya excel ka buy krna tha
Nice and good explanation.
Very simple explanation
Sir excel se excel me pay slip banana hai hajaro longo ka please ek video बनाइये
Masha Allah zabardast
Very helpful... thanks
I have one example. You please help me to create formula in excel
Bahut acche sir. Nice impressive vlookup video.
Sir main is task ko , vlookup, vlookup+match, vlookup+ coloumns, vlookup+array, index match, offset vlookup se bhi ker sakta huu
Very good prashant 👍👍👍🔥
@@DeepakEduWorld lekin sir aap ke takreeban sab video ke assigments files mere pass load hain jis per maine bahut practice ki jis se main yw sab sheekh paya. Sirf aap se ik nivedan hai ki vlookup +indirect fuction with sheets and diffrent workbooks is per video banaye. Sirf ik indirect wala concept hi samaj nahi aata bahut try kiya aur bahut video dekhe but clear nahi huaa. Aap ka samjhane ka tareeka samaj mein aane wala hai id liye aap se kaha. Aap ka channel aise harkee karta rahe aur jo kahin fees dene mein asmarth ho wo aap se bahut kuch seekh sakte hai. Danywaad
You are amazing ❤
nice
BHAI JI KAYA MAST DATA DIYA HAI. THANKS
Boht Aala barya
Hello sir
Total sales Pe brands wise % kaise nikLte formula banav
Nice
Tq very much sir
1.rohit sharma
2.mohammed siraj
3.logan Ben veek
Will this formula still work if I enter new data in sheet1 ??😢
Yes
Sir 2d lookup best way kese lagaye match ka use nahi karna he
Thanks for guiding us 🙏
Sir plz give formula how you find out DA, CA, HRA, TA etc plzzz
No.1 video
👌
Left side column without working vlookup formula what formula use xlookup not in my system which formula use
please do it for some compounds data in biology..
What if i want only selected column only while dragg
very useful sir
Wow
Thanks bro
Nice sir
Thanks sir
best concept
perfect bro
well explained
HAPPY GURU PURNIMA SIR 🙏💐🙏
Thanks 🙏 priyanka g… god bless you 🙏
@@DeepakEduWorldschool report card pe video bna sakte hai? Different subjects like science stream PCB, PCM, jisme students ka subjects mark stream ke anusar roll no wise report card generate ho?
Bhai main Excel google sheet use karta hu par usme main ek problem a rha hai to kya please meri help karo ge mene sbhi jagh dhoon dha par solution nahi mil rha hai plase help karo
Very good
Sir please solve my problem.ek sheet me ho kara dusre sheet ka data kese dekhenge large database me
Amazing
Video like kardiya was epic😂😂😅😅👍👍👍
Bhai vlookup aur match sath me use kare to bhi hota hai 🤔
Bhai socho Mera pass 5 country ka 25 mobile number hai country code ke sath jaise ki india ka +91 to mujhe har country ka number ko alag alag kaise Excel me please ek video banao
Excel sy Call data record (CDR) ko A4 page pr kese print krain k sara data 1 page pr aaye
Excel ka format de dijiye sir ji
do we have to write same code for every entities?
what if me ek sath 8-10 emp id sirf copy paste kru or date show ho jaye
Thank u
🥰thank u sir
Great
BUT JAB HUM LOOKUP VALUE FIX KAR DENGE, TO NICHE OTHER EMPLOYEE KA DATA KESE AAYEGA, DRAG AND DROP SE
Pls tell how do we apply vlookup for the rest of the employee id in sheet 3