How To Apply VLOOKUP and XLOOKUP formula on Large / Big Data in Excel (Hindi)

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'

[@DeepakEduWorld]

Dosto kaisa laga video 😊

[@khiladichunky3673]

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

[@apocalypsematrix9252]

THUMBS UP 👍🏻 VELI VELI LEMONI, GABAR 😎 KA ASLI PASAND

[@nanig9385]

You are best the teacher

[@rehan2520]

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

[@rehan2520]

@@nileshkathe5916 Niles ap ko kesy pta ya recorded video ha

[@tulasichamlagain8749]

I love watching your excell tricks. They really are worthy of investing time on. I am a big fan of your presentation too.

[@ubaidshaikh3615]

Always ki traah....super se bhi upar ....100 💯% excellent Excel work

[@basantornithologist2030]

Different types of formula by u is interesting. Thank u Sir

[@onkarkachale8858]

Thank you I learn something new today.
Even I shared with my friends.

[@kinzalakhani4671]

Thank you ❤️ your video made my concepts clear

[@shahidrazzaq1630]

Dear Sir
I regularly watch your videos, and learn a lot from you.
Thank you very much, stay blessed.
Shahid from Pakistan.

[@sakilnewaz-pt3zk]

Sir mind blowing
Thanku u so much

[@khurramaftab7741]

Thank you for great information

[@Santoshkumar-iz2io]

Great boss.....sweet and simple with short time and clarity

[@user-ho5bx7yh7o]

Love you bro nice app achy sy gaide krty Hain thanks

[@mohammedaleem1256]

Thanks a lot for the video.

[@shahnawaz.chakaria]

Amazing learning Method, watching from Bangladesh 🇧🇩

[@WaqasAhmad-jj5cn]

really v good, informative, easy to understand, video. loved it. thanks

[@anaghapradhan7745]

Very helpful... thanks

[@user-px1zh5tp2t]

Ek No🙏

[@nikhilkasurde504]

Thanks for guiding us 🙏

[@nishanth4323]

Gajab 👏👏👏👌

[@syedikramullah1114]

Nice and good explanation.

[@sureshv7724]

Very well explained,
You are top class,
Made is simple and explained the functions.
Amazing Baiya 👏

[@user-up5xu9iz4s]

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?

[@Muhammad_Asif_1978]

Great ,,, excellent
👍❤❤❤❤❤❤❤❤

[@AbdulLatif-ce5ow]

Sir, please teach us how to find full record of such a large data from columns into rows throgh vlookup.. Like DMC etc.

[@humrazbarag7119]

Buhut acha Laga sir

[@littlemaster8517]

Very helpful sir for comparing large data

[@bhaveshparmar431]

One step ahead ❤

[@gauravprajapati7034]

Mind blowing 😊😊😊😊

[@AnkitSharma-ym8db]

Awesome deepak

[@Sanurathoreofficial]

Very helpful video sir

[@iamlalitrawat9474]

BHAI JI KAYA MAST DATA DIYA HAI. THANKS

[@heartnoice5460]

You are amazing ❤

[@mdasgaransari295]

Awesome 👍

[@vikrammodi9584]

Excellent sir

[@dvaibhav1]

No.1 video
👌

[@5bacchewithfun]

Accha laga sir

[@Arifrasheedqw]

THANK U SOO MUCH ITS A GREAT

[@amzedkhan5854]

Very useful

[@Arjunpandit806]

Wao nice vedio

[@mykids4556]

Ek nambar sir

[@_xtylish_boy_pankaj_10k]

good enformation

[@sai-qj9ly]

Tq very much sir

[@mdshofiqulazom4841]

very useful sir

[@user-vd3eq7bj1s]

perfect bro

[@mahendergodara3229]

Very simple explanation

[@maheshsingh1612]

Thankyou sir

[@PiyushDedhia]

well explained

[@nishant9001]

I like your last style topic 👍😁

[@humrazbarag7119]

Very nice sir

[@user-ny6zc7vg9o]

Thanks bro

[@user-zf8jp5hs4p]

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

[@ytbollywood7586]

Thanks sir

[@ranjangouda3687]

🥰thank u sir

[@maheshsaini3458]

Very nice sir 🎉🥳🎉

[@anujmaurya3131]

best concept

[@pratiksurti1850]

thank u

[@harishankarreddysegu4453]

This video was like a lightbulb turning on in my head. So informative and easy to learn and deploy.

[@InderSingh-uk5vl]

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 😅

[@user-gv7ll2lc4n]

Boht Aala barya

[@subratapanda9195]

Thank u

[@DKTECH]

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

[@DeepakEduWorld]

Education

[@user-hy9gg3cs5p]

Great

[@Genius_Mukim]

Amazing

[@zulfiqarali-qs3ww]

Very good

[@parthasen3223]

Very nice.
Sir...xlookup download kayese kare dikha dijiye..pls

[@princechandanpura123]

Nice sir

[@janmejayagangwar5665]

Very helpful ....super

[@farazamir-mi7et]

right from pakistan

[@anandsathe616]

👍👍👌👌

[@graphicsline5383]

How can we add, subtract and multiply of algebraic equations in Ms excel ?

[@Kabir89753]

Nice

[@anilgautam1656]

THANKYOU WOULD BE A SMALL WORD FOR THIS KNOWLEDGE WHICH YOU HAS PRIVIDED HERE . . . .. . . . BUT " THANKYOU "

[@anaghapradhan7745]

U r completely saver for us when it comes to excel

[@Pr.MaqsoodBhatti]

Super

[@vijaypatel5269]

Wow

[@mr.logician1915]

Video like kardiya was epic😂😂😅😅👍👍👍

[@user-nt1kv7vj8s]

nice

[@learnandexplore1562]

please do it for some compounds data in biology..

[@nirajsingh4013]

BEST

[@SoumyaTheMusicalMan]

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

[@princejaswal5728]

What if i want only selected column only while dragg

[@AmitGupta-bl2iu]

Sir apka course hai kya excel ka buy krna tha

[@prashantrangari5110]

Hello sir
Total sales Pe brands wise % kaise nikLte formula banav

[@manojsinhzala4422]

I have one example. You please help me to create formula in excel

[@parimalpatel4827]

Sir 2d lookup best way kese lagaye match ka use nahi karna he

[@user-lm3xv5yf3p]

Left side column without working vlookup formula what formula use xlookup not in my system which formula use

[@tharudeep827]

Sir excel se excel me pay slip banana hai hajaro longo ka please ek video बनाइये

[@manavrajavat4355]

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

[@sachinm7631]

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

[@vminkookk]

Bahut accha 😅😅😅😮

[@Cottawarriors69]

❤❤❤

[@mailmesahil87]

Video to accha hai sir. Ek part reh gya. Isko drag down kaise karenge?

[@benishrafi2894]

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

[@pritishreekerai2110]

Sir please tell me how to data entry input or output

[@blacksparrow6950]

Bhai ur savier

[@sachitkumar7898]

1.rohit sharma
2.mohammed siraj
3.logan Ben veek

[@amirranashahzad8513]

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

[@purnimakundu1239]

Sir plz give formula how you find out DA, CA, HRA, TA etc plzzz

[@priyankabhadlekar6999]

HAPPY GURU PURNIMA SIR 🙏💐🙏

[@DeepakEduWorld]

Thanks 🙏 priyanka g… god bless you 🙏

[@548KAMAL]

​@@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?

[@manojitdey3323]

i have a problem sir will u solve it? If C4=Holiday then merge C4:J4

[@user-qp8ho9tq8u]

no link yet but payment made and not even received any message

[@vkeditor12]

Sir ek video iferrorvlookup par video pana do

[@aratisahoo9688]

Sir please solve my problem.ek sheet me ho kara dusre sheet ka data kese dekhenge large database me