How to apply VLOOKUP on Large / Big Data in Excel (Hindi)

Video quality	The size	Download

Information How to apply VLOOKUP on Large / Big Data in Excel (Hindi)

Title	:	How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
Lasting	:	10.06
Date of publication	:
Views	:	598 rb

Buy Excel & Word Course 👉 TechGuruPluscombrDownload Practice File 👉 techgurupluscom/vlookup-on-large-big-data-in-excel/ brDownload All Projects 👉 techgurupluscom/excel-project-practice-files-download/
Comment from : @business-excel

Thanks u guru ji
Comment from : @agxxarif5375

Thank you sir 😢 🙏 Vlookup me bahut jyada problem aata tha but aapne Aaj clear kar diya hai Me aapka Excel ka cource purchase krunga 🙏
Comment from : @sundramdwivedi7300

hi dost mujhe 1 hi sheet m 3 colum match krwane hai or 3 no cloum mein customer ka adress hai mailing adrrss prement adress or residents adress ab is ko kaiss match karein gai
Comment from : @sikandarismail1608

Xlookup kam krega kya sir😢
Comment from : @saketsingh1729

thanks
Comment from : @sunilsachan4248

best one is 648 sec seems like you are matured content creatorhow did i missed you on youtube
Comment from : @user-ik8jp1tt4o

Discover the game-changing formula that will make you say goodbye to Vlookup, Hlookup, Index+Match, and Xlookup Trust me, your perspective will never be the same! brJust Search on Google br"Say goodbye to Xlookup"
Comment from : @user-hf4cd9fk3j

Sir Mera question hai me pas data hai jiska mai master sheet par auto calculate karna hai data hai loading date/ veh no/company name/own veh/hire veh/wt in master shaat auto calculate total company wise own/hire total trip or today trip
Comment from : @DilipKumar-ev1fy

Thanks
Comment from : @user-wu5my2th1l

Bhai mere pass esa formula hai sumfis sumproduct v lookup h lookup sab kuch ek mai ho kar dunga
Comment from : @ahmadsufiyan4859

It's wrong method
Comment from : @martinmathew3554

Awesome 👌
Comment from : @kiranmore1733

You are Great sir🙏
Comment from : @thetechtipps

Wonderfull Sir ji
Comment from : @thetechtipps

Can we apply vlookup on same sheet??
Comment from : @powerdoorsautomations9667

Hello sir, sir excel me jab bhi ham koi value ya kuchh bhi find karte hai to wo cell auto colour ho jaye kiya aisa ho sakta hai
Comment from : @shyammishrafanclub7996

Table arrey ko lock krne ke liye kon si key ka use karna hai?
Comment from : @shallenderchauhan5983

How much time press F4 ?
Comment from : @MdKhokon-xu1np

Awesome sir ji❤Aap best teacher ho sir ji❤ek ek step aap ne samjhaya 🙏
Comment from : @educatedsugla0519

Thank you so much sir aap ne confusion dur ki❤aap ne easy way bataya😍
Comment from : @educatedsugla0519

Hi sir, I need to buy ur classes How to buy this?
Comment from : @KiranKumar-zw8re

Thank you
Comment from : @harshparab5537

Match Formula sey bhi ho skta h kya yehoutput same ayega?
Comment from : @karangupta8005

Sabse best l Vlookup with match Row rows column and columns kii need nahii hotii jab hum v lookup with match use karte h to Isliye best option match rehta h
Comment from : @AlimKhan-bl5sh

We can use match and index
Comment from : @nehashukla7609

Thank you sir
Comment from : @wpresident1

How to use same table sumifs formula
Comment from : @user-hx8ub1eu6t

Tq so much
Comment from : @ashwanipatil8452

Hi sir, could you please create more videos upon large data more than 1000 records in a sheet with different columns ,brthanks alot for sharing your valuable experiance,
Comment from : @moiuddin121

Very nice explanation
Comment from : @TeluguBashaShow

Thanks u sir for you give us practice sheet❤❤❤
Comment from : @daingflipper

Nice one dear
Comment from : @bestlearnings4265

Thanks 🙏 sir
Comment from : @9110angadLala

Sir ap Gla university me bhi padhate hai kya????
Comment from : @kumargaurav2383

Sir I couldn't copy formula in horizontal way
Comment from : @nandishnandi8299

sir men kesi cheez ka demand deta hon 500 pcs nuts ki or mujh receive howe hain 400 or phir men demand deta hon 510 ki or received hote hain 510 nut jo equal hoty hain to sir equal ka condition formula apply kr k green ka color deta hon phir men demand deta hon 40 pcs ka or received 40 hote hain mgr formula equal condition apply nhn ho sir plzzz help kren thanks
Comment from : @noobplayergaming1093

Column formula is creating an error in vlookup?
Comment from : @syedkamal8840

बहुत बहुत आभार sir आपका
Comment from : @sandeeplowanshi9

Sir, i downloded file applied learned formulas and result are mismatched After spending an hour i came to know that result are also mismatched in your file Please check & share with us
Comment from : @khawajamuhammadadil4802

Hello, I need to ask you if there is a way to filter out any newly entered data in an excel sheet using VLookup function? Actually I work at a school, since it's admissions season so my boss updates new students lists every couple of days and it gives me headache to find which new students got admitted in such a big data sheet When I asked my boss he told me to use Vlookup function to find out the newly added data but I really don't know this use of the VLOOKUP function Would you please guide me if there is such way of finding a newly added data in an excel sheet?
Comment from : @shufang5613

Sir muje Excel me vo formula chahi ye jo minit column me likha ho wo row me aromatic aa jaye
Comment from : @bhaviksolanki3683

Mera to Bina column lagaye aa raha hai, column laga raha hoon to galat ho jaa raha hai
Comment from : @sushant5242

sir mein jab same sheet pe formula use kar raha hoon tab ho raha hai likin jab do sheet pe kar raha hoon tab nahi ho raha hai
Comment from : @DeltaTraderSorav

I have a problem Can you help?brI have a master sheet of HS students contains sl no, Name and registration number with 7 subjects My problem is to make list of students who have a particular subject (BENG, ENGB, GEGR, CHEM) etc How can I do it
Comment from : @asishkarmakar974

Sir mujhe thoda bhi nahi aa rha tha but ab samjh me aa gya
Comment from : @sardaransari1430

Very tough method 😔
Comment from : @professor_skills320

I did it with using vlookup match and hlookup match both waysthankyou for your trick also
Comment from : @gauravnainwal3239

We can see Vlookup + Match
Comment from : @imranshaikh2431

Awesome bhout aacha se explain kiya sir Aap na😊
Comment from : @indreshbhardwaj5277

Highly appreciate it and highly recommended, very well explained extremely helpful thank u sir
Comment from : @sky-high9123

Can we generate students annual report by using excel sheet in word documentcharacter report basing on there performance in each subject
Comment from : @Quran_thesolution

Tq sir❤
Comment from : @prakashdas5285

Sir,same date me company 1000 above party krti aor kuch party joki company me add but vo payment nhi too ham Vlookup formula se kese pata kare kon si party payment nhi ki
Comment from : @user-fy8dn7ow1h

please sir reply me
Comment from : @vinodkumarmaurya2893

sir kisi bhi excel sheet me bahut sare village diye gaye hai use hum kaise pata kare koin sa village kitne pracentage hai
Comment from : @vinodkumarmaurya2893

Thanks Sir
Comment from : @DeepakSharma-rb6tv

Hello SirbrThank you so much The way you teaching is really easy to understand, thumbs upbr*brB Regardsbr-NasiR
Comment from : @dreamparadise1520

Sir ye sheet share kar dete😢
Comment from : @tradertalk001

Knowledge video
Comment from : @sdking1802

sir after applying Vlookup formula in large cell when i drag right site Vlookup value reflected and when i drag down upper row deta is reflected in other column please check and resolved the issue
Comment from : @ShubhamTiwari-yx1lp

If we don't data not in sequence
Comment from : @dharamveergautam5697

Sir agar ye Excel ki file download karna ho practice k liye to kaha se karna padega
Comment from : @sujitmehta545

Match se bhi to ho sakta tha?
Comment from : @shiveshhsharmaa9668

YOU HAVE DONE MY WORK SO EASY I HAVE DONE ONE CHANGE IN PLACE OF COUMN I HAVE WRITTEN ROW(CELL) AND I GOT EXACT RESULT AS PER MY DATA THANK A LOT DEAR
Comment from : @dmobanaskantha8685

Sir mane pahle hi socha tha ki Coulom 2 ke place pr coulom ya match ka formula use karna chahiye tha , number ke liye match ka formula bhi lga sakte h na 😊😅ya phir index+match dono combination ka formula, 😮
Comment from : @Trending_video0172

Thank you
Comment from : @johnwebster4751

Very Nice
Comment from : @GayanPapi

Really helpful filethank you soo much
Comment from : @user-oq6st7qw3g

I sometime face error while applying vlookup my data gets arranged in ascending orderbrPlease help
Comment from : @sparshgupta5245

SIR LAW FIRM ME BHI EXCEL KA USE HOTA AUR KAISE DATA PAR USE HOTA HAIANY IDEA SIR JI
Comment from : @Abhisheksoni8738

Very helpful
Comment from : @afrinkhanam7537

Thanks bro Simple and good
Comment from : @SameerShaikh-sc2kz

Thanks
Comment from : @cpp1517

i dont know hindi but i did understand allits a mix of english delspanish/del portuguese
Comment from : @mochissin84m84

Sir mere ko basic say suru krna hai to help me
Comment from : @rahulkumar-gi6oh

Assalamualaikum, How can i create unique id with 4-5 column
Comment from : @user-wu6hw7tw1d

जब हम डाटा में फिल्टर लगाते है और हम चाहते है की हमने जो सेल्ड्ट किया है सिर्फ उस का टोटल नीचे दिखे brउसे के लिए तरीका दे सर
Comment from : @VijendraloveSong

Mene kitne video dekhe ES k liye par samjh nahi ayya brAap ne bohot badiya tarike s samjya 👍
Comment from : @VijendraloveSong

boht sari videos h lookup cy related but jo apna smjhaya h na sir hatsoff
Comment from : @user-pc7bi6op5s

Sir without formula multiple values ko copy paste kar sakte hai
Comment from : @arshadalisiddiqui5649

Sir, colomn me next step me false likhre hai to nai aara 0 likhne pe aara hai aisa kyu
Comment from : @hknagar245

Sir mujhe interest calculation karna hai Jaha Below 100000 k 4 and above 100000 k 5 kaise formula lik chunga
Comment from : @radhakantafriends9822

the best explanation of vlookup in the most simplest way, all the best Sir
Comment from : @kunalmarwah23

this is the best way of learn very nice sir
Comment from : @dharmendersingh2637

Sir mujhe mis executive ki job k liye course karna hai please guide me mujhe computer ata hai but confidence nh banta isiliye job nh mil pati please help
Comment from : @Xkaran73x

Please make a video of large data on different sheet
Comment from : @Glavya

sir aisa bhi koi formula hai jis se ham sare data me se only name hi nhi kuchh bhi ek cheez likhde to uski saari details aa jaye?
Comment from : @Bhai_Harshdeep_Singh_Ji

Hello Sir, I am from Pakistan and I am much impressed with your skills and knowledge I want advance excel course Can you please help me here? Many thanks
Comment from : @khanishaq5316

Sir, 1 question h mera brbrKi agr hum vlookup lgate h 2 sheet mebrJaise 1st sheet m 50 items hbr2nd sheet me 60 items hbrbrTo remaining 10 konse hai kaise pata chalega??brbrUsme vlookup hi use krenge y kuch or use krenge?brAgr kuch or use krenge to konsa??brbrbrbrSir please help me on this query brYour prompt response is highly appreciated
Comment from : @deepsagarpatil

Mera column wise data nahi nikala raha ha
Comment from : @iamflash2765

Sir Mera nahi ho raha ha
Comment from : @iamflash2765

Thanks a lot sir exactly i needed this one
Comment from : @user-lg3ee7gl1s

Excellent
Comment from : @aniyaliyarakesh3438

Thanks u Sir, for helping
Comment from : @pramodgadikar4318

Hello sirbrbrI have Office Student and Home 2021brDoes Ms Excel have all the features which required to learn for jobs
Comment from : @kingfighter08

Bahut achche se app ne explain kiye hai vlookup ke bare me thanks sir❤
Comment from : @laptopgharpatnabihar1637

Vlookup formula lagane ke baad , vlookup data jo aata hai usmai correction kar ke or wo correction Kiya hua data automatically main data me update kese kare?sir plzz answer
Comment from : @ashvingamad8271