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
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
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
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 😅
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
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?
@@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?
Thank you sir for the informative video. But I would like to add one thing here and that is at 3:47 seconds you have shown that we need to freeze the lookup value ($A$2) which is ok as far as we are dragging the formula to the right side of the cells. But when we will drag down the formula downwards here we will not get exact result rather only the data of (A2) will get dragged down as we have freezed the lookup value. So in order to get the correct data both the sides (right side as well as downwards for rest data) then we need only to free the column A - ($A2) barring the row number so that the formula also gets dragged downwards. Kindly correct me if I am wrong sir.
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
@@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
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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![How To Apply INDEX and Match Formula on Large Data in Excel [Hindi] #excel](/img/n.gif)
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
Thanks sir aapki wajah se merko bhot zyada appreciate kara hai mere office boss ne thankyou so so much❤ great teacher
I love watching your excell tricks. They really are worthy of investing time on. I am a big fan of your presentation too.
Always ki traah....super se bhi upar ....100 💯% excellent Excel work
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
Different types of formula by u is interesting. Thank u Sir
Very well explained,
You are top class,
Made is simple and explained the functions.
Amazing Baiya 👏
Thank you for great information
Amazing learning Method, watching from Bangladesh 🇧🇩
Thank you ❤️ your video made my concepts clear
Thanks a lot for the video.
Thank you I learn something new today.
Even I shared with my friends.
Sir very nice video for information ❤
Dear Sir
I regularly watch your videos, and learn a lot from you.
Thank you very much, stay blessed.
Shahid from Pakistan.
One step ahead ❤
Awesome deepak
Ek No🙏
Great ,,, excellent
👍❤❤❤❤❤❤❤❤
Very useful
Mind blowing 😊😊😊😊
I like your last style topic 👍😁
Excellent sir
Very nice sir
Accha laga sir
Buhut acha Laga sir
Wao nice vedio
Very nice sir 🎉🥳🎉
Awesome 👍
Gajab 👏👏👏👌
Great boss.....sweet and simple with short time and clarity
Very helpful... thanks
good enformation
U r completely saver for us when it comes to excel
Very helpful sir for comparing large data
Sir mind blowing
Thanku u so much
Very helpful ....super
right from pakistan
Ek nambar sir
Nice and good explanation.
Very simple explanation
Boht Aala barya
This video was like a lightbulb turning on in my head. So informative and easy to learn and deploy.
Very helpful video sir
Super
THANK U SOO MUCH ITS A GREAT
Thankyou sir
Love you bro nice app achy sy gaide krty Hain thanks
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 😅
Very nice.
Sir...xlookup download kayese kare dikha dijiye..pls
You are amazing ❤
No.1 video
👌
well explained
very useful sir
thank u
Sir apka course hai kya excel ka buy krna tha
Bahot acha sir😊
Thanks for guiding us 🙏
really v good, informative, easy to understand, video. loved it. thanks
BHAI JI KAYA MAST DATA DIYA HAI. THANKS
Masha Allah zabardast
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
Tq very much sir
best concept
perfect bro
Thanks bro
Sir Columns ke alawa Match bhi use kar sakte hai na ?
nice
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
Nice sir
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?
Amazing
Video like kardiya was epic😂😂😅😅👍👍👍
please do it for some compounds data in biology..
🥰thank u sir
THANKYOU WOULD BE A SMALL WORD FOR THIS KNOWLEDGE WHICH YOU HAS PRIVIDED HERE . . . .. . . . BUT " THANKYOU "
Wow
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?
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
Great
Thank you sir for the informative video.
But I would like to add one thing here and that is at 3:47 seconds you have shown that we need to freeze the lookup value ($A$2) which is ok as far as we are dragging the formula to the right side of the cells. But when we will drag down the formula downwards here we will not get exact result rather only the data of (A2) will get dragged down as we have freezed the lookup value. So in order to get the correct data both the sides (right side as well as downwards for rest data) then we need only to free the column A - ($A2) barring the row number so that the formula also gets dragged downwards.
Kindly correct me if I am wrong sir.
Hello sir
Total sales Pe brands wise % kaise nikLte formula banav
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
Nice
Very good
Sir excel se excel me pay slip banana hai hajaro longo ka please ek video बनाइये
What if i want only selected column only while dragg
Sir 2d lookup best way kese lagaye match ka use nahi karna he
Sir, please teach us how to find full record of such a large data from columns into rows throgh vlookup.. Like DMC etc.
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
Sir plz give formula how you find out DA, CA, HRA, TA etc plzzz
Left side column without working vlookup formula what formula use xlookup not in my system which formula use
Sir please solve my problem.ek sheet me ho kara dusre sheet ka data kese dekhenge large database me
Bhai vlookup aur match sath me use kare to bhi hota hai 🤔
BEST
I have one example. You please help me to create formula in excel
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
Will this formula still work if I enter new data in sheet1 ??😢
Yes
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
Sir ek video iferrorvlookup par video pana do
Excel ka format de dijiye sir ji
Sir, aapka koi online Excel course hai?