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
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
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 😅
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?
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
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.
@@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?
Sir mera question tha agar bata denge to bahut mehrbani hogi Q- aapne jo Vlookup formula use Kiya hai usse Emp I'd dalenge to ek employee ka pura details aayega aur wah ek linge me har employee ka Emp I'd baar baar dalnaa padega Agar mujhe ek hi baar me formula use kar ke 50 employee ka Emp I'd lana hoto kaise karenge
Sir mera ek question hai agar aap solve kr de meri kaafi help hg . Mera xyz koi product hai jisko main alag alag rate main purchase krta hu or alag alag rate main selles bhi krta hu uska stock main kese maintain kruga or profit bhi pta chal jaye Ex. Product Purchase rate Shoes 10 Shoes 20 Shoes 50 Products sale Rate Shoes 30 ----- 80
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
Excellent work But bro how can manage this data So there are 4 categories. The categories must come to their number per month divided by the days listed below. But it must not exceed the maximum per day that I indicate in the list below. For example, if Tag1: has 786 people, the number must be the same and not higher. Category 1 total monthly: 12431 Category 2 total monthly: 2726 Category 3 total monthly: 1362 Category 4 total monthly: 510 maximum person per day: ( the numbers must correspond exactly to the days as specified, not over and not less!) day 1 786 day 2 744 day 3 719 day 4 701 day 5 692 day 6 684 day 7 689 day 8 680 day 9 677 day 10 683 day 11 679 day 12 671 day 13 659 day 14 639 day 15 602 day 16 584 day 17 570 day 18 554 day 19 533 day 20 505 day 21 489 day 22 462 day 23 436 day 24 418 day 25 391 day 26 369 day 27 344 day 28 302 day 29 279 day 30 255 day 31 233
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![fellow fellow - พรุ่งนี้ไม่มีใครรู้ feat. INK WARUNTORN [OFFICIAL MV]](http://i.ytimg.com/vi/QP6JyjYx_W0/mqdefault.jpg)
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.
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
Dear Sir
I regularly watch your videos, and learn a lot from you.
Thank you very much, stay blessed.
Shahid from Pakistan.
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
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 😅
Always ki traah....super se bhi upar ....100 💯% excellent Excel work
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?
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 👏
Amazing learning Method, watching from Bangladesh 🇧🇩
Thanks sir aapki wajah se merko bhot zyada appreciate kara hai mere office boss ne thankyou so so much❤ great teacher
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
Very nice.
Sir...xlookup download kayese kare dikha dijiye..pls
Thank you I learn something new today.
Even I shared with my friends.
Thank you ❤️ your video made my concepts clear
Mind blowing 👌👌 Thank you very much
1.rohit sharma
2.mohammed siraj
3.logan Ben veek
Sir very nice video for information ❤
I like your last style topic 👍😁
Sir Columns ke alawa Match bhi use kar sakte hai na ?
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
Thanks a lot for the video.
Buhut acha Laga sir
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.
Thank you for great information
Great boss.....sweet and simple with short time and clarity
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 ,,, excellent
👍❤❤❤❤❤❤❤❤
U r completely saver for us when it comes to excel
good enformation
Very nice sir
Ek No🙏
Very nice sir 🎉🥳🎉
BHAI JI KAYA MAST DATA DIYA HAI. THANKS
=Lookup value fix, tablet array fix, column (..),0) enter
Very helpful sir for comparing large data
Love you bro nice app achy sy gaide krty Hain thanks
Sir apka course hai kya excel ka buy krna tha
Sir excel se excel me pay slip banana hai hajaro longo ka please ek video बनाइये
THANKYOU WOULD BE A SMALL WORD FOR THIS KNOWLEDGE WHICH YOU HAS PRIVIDED HERE . . . .. . . . BUT " THANKYOU "
One step ahead ❤
Accha laga sir
Excellent sir
Mind blowing 😊😊😊😊
Awesome deepak
THANK U SOO MUCH ITS A GREAT
Very simple explanation
really v good, informative, easy to understand, video. loved it. thanks
Wao nice vedio
Video like kardiya was epic😂😂😅😅👍👍👍
Nice and good explanation.
Very helpful ....super
right from pakistan
Very helpful... thanks
Gajab 👏👏👏👌
Bahot acha sir😊
You are amazing ❤
No.1 video
👌
Very helpful video sir
Sir mind blowing
Thanku u so much
Thanks for guiding us 🙏
Very useful
Ek nambar 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
Awesome 👍
Masha Allah zabardast
This video was like a lightbulb turning on in my head. So informative and easy to learn and deploy.
Boht Aala barya
Hello sir
Total sales Pe brands wise % kaise nikLte formula banav
best concept
very useful sir
Tq very much sir
well explained
Sir, aapka koi online Excel course hai?
please do it for some compounds data in biology..
Sir plz give formula how you find out DA, CA, HRA, TA etc plzzz
perfect bro
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?
Ye single row ke liye tha. uske niche aur data lana hoga to kaise karenge sir?
Sir, please teach us how to find full record of such a large data from columns into rows throgh vlookup.. Like DMC etc.
Agr empid ke bina empname de diya toh lookup value kya ayegi sirr...?
Thanks bro
Super
Bhai vlookup aur match sath me use kare to bhi hota hai 🤔
Sir mera question tha agar bata denge to bahut mehrbani hogi
Q- aapne jo Vlookup formula use Kiya hai usse Emp I'd dalenge to ek employee ka pura details aayega aur wah ek linge me har employee ka Emp I'd baar baar dalnaa padega
Agar mujhe ek hi baar me formula use kar ke 50 employee ka Emp I'd lana hoto kaise karenge
Sir mera ek question hai agar aap solve kr de meri kaafi help hg .
Mera xyz koi product hai jisko main alag alag rate main purchase krta hu or alag alag rate main selles bhi krta hu uska stock main kese maintain kruga or profit bhi pta chal jaye
Ex. Product Purchase rate
Shoes 10
Shoes 20
Shoes 50
Products sale Rate
Shoes 30
----- 80
I have one example. You please help me to create formula in excel
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 agar emp id 1 se jyada hai to uske liye aur bta dete ismein..kyonki freeze krne mein dikkat ayegi badi list mein..
Nice sir
Desination❌ Designation ✅
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
nice
Xlookup How to Create Mark Sheet in MS Excel step by step Fully Automatic Marksheet In Excel . horizontal to vertical converter
Thank u
🥰thank u sir
Pls tell how do we apply vlookup for the rest of the employee id in sheet 3
Excellent work
But bro how can manage this data
So there are 4 categories. The categories must come to their number per month divided by the days listed below. But it must not exceed the maximum per day that I indicate in the list below.
For example, if Tag1: has 786 people, the number must be the same and not higher.
Category 1 total monthly: 12431
Category 2 total monthly: 2726
Category 3 total monthly: 1362
Category 4 total monthly: 510
maximum person per day: ( the numbers must correspond exactly to the days as specified, not over and not less!)
day 1 786
day 2 744
day 3 719
day 4 701
day 5 692
day 6 684
day 7 689
day 8 680
day 9 677
day 10 683
day 11 679
day 12 671
day 13 659
day 14 639
day 15 602
day 16 584
day 17 570
day 18 554
day 19 533
day 20 505
day 21 489
day 22 462
day 23 436
day 24 418
day 25 391
day 26 369
day 27 344
day 28 302
day 29 279
day 30 255
day 31 233
What if i want only selected column only while dragg
Sir ek video iferrorvlookup par video pana do