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

Download Practice File 👉 techguruplus.c...
Buy Excel & Word Course 👉 TechGuruPlus.com
Download All Projects 👉 techguruplus.c...
.
Telegram Group 👉 t.me/TechGuruPlus
My Instagram 👉 / techguruplus
Facebook Group 👉 / excelexpertgroup
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel Videos
🔹 • Top 20: Advanced Excel...
(2) Tally Videos
🔹 • Email through Tally wi...
(3) Sponsored Videos
🔹 • Edraw Max: Perfect Sof...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Contact for Business Inquiry
➟ [e-mail]
➟ Website: www.TechGuruPl...
#Call_9536250020_to_Join_Advance_Excel_Course #TechGuruPlus #NazimKhan

[@business-excel]

Buy Excel & Word Course 👉 TechGuruPlus.com Download Practice File 👉 techguruplus.com/vlookup-on-large-big-data-in-excel/ Download All Projects 👉 techguruplus.com/excel-project-practice-files-download/

[@Pankajkumar-bh1xq]

Sir simple vlookup formula se bhi ho rha sare values shi ayi A

[@shashankbingi3436]

Hello as you explained in the video if there are category like 5 brands each brand has monthly sales targets for 5 stores or persons how do we use vlookup in this scenario

[@shashankbingi3436]

I could send you a image if there is an option

[@AvinashSingh-im4oc]

Sir App phele jaha V lookup apply Krna hai un sare cells ko select kr lejea uske Bad Ume Vlookup ke sath Match function use kijea Formula auchhe se Lekne ke bad Cntrl hold krke Enter dba dijea Isse sare cell me ek Bar me V lookup apply Hojayega

[@mecharenarptp172]

2:47 sir मेरी एक sheet है usame date wise जेसे 1-2-2023 pir 1-3-2023 with number उसकी details bi aajaye

[@Hotnews1111]

THANK YOU SO MUCH SIR LOTS OF LOVE FROM NEPAL

[@business-excel]

Thanks you too

[@abdulmoid]

Excellent sir, make understand hard thing in easy way, it is your great skill. thanks

[@advaitanarula7670]

Sir, you are too good with this!! Thanks a ton!! Really God bless you

[@business-excel]

🙏🙏

[@babai9277]

​@@business-excel Is data main vlookup ki jaga exact+match function bhi use kar sakhte hai na?

[@youtubenemr6293]

Wonderful explanation sir great 👌👌

[@hollywoodhindimovies5487]

Thanks sir really helped me a lot. But sir when iam applying for data which have random columns tab kaise lagega ye formula. For ex yaha 1st jan ki ki jagah 2 jan uske baad 5 jan aise random hota to kaise ek baar me data late. Please help

[@simransingh8042]

But in my opinion to use this the column position in both the table has to be the same. right?

[@vishwajeetsingh3755]

I use to have 60-70 lacs row data with 87 columns, divided in 7 sheets every sheet 10 lac data every month. I have to prepare summary and lookup frequently, please suggest the way, excel get stuck 780 mb excel file.

[@Glavya]

Please make a video of large data on different sheet

[@khanishaq5316]

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

[@TheWorkspaceHacks]

Welcome my friend! There are lots of channels are available for free advanced courses. If you find nothing please let know i will recommend you something.. thanks

[@Deepakkumarrko]

Thanks You

[@bhaveshbaghele5745]

Can we use match function to fetch column number

[@thetechtipps]

Wonderfull Sir ji

[@dipteshdutta4176]

Duplicate karne se vi dekh sakte ho "Rohit Sharma" ki data

[@bestlearnings4265]

Nice one dear

[@deepsagarpatil]

Sir, 1 question h mera Ki agr hum vlookup lgate h 2 sheet me Jaise 1st sheet m 50 items h 2nd sheet me 60 items h To remaining 10 konse hai kaise pata chalega?? Usme vlookup hi use krenge y kuch or use krenge? Agr kuch or use krenge to konsa?? Sir please help me on this query Your prompt response is highly appreciated

[@pankajsaini50]

Thank you so much sir, सर मुझे ये कॉलम फंक्शन से आता था vlookup, लेकिन मैं जब कभी भी लगाता था थोड़ा सा कंफ्यूज हो जाता था, लेकिन आपने इतना आसानी से समझाया की जिंदगीभर के लिए दिमाग में बैठ गया। थैंक यू अगेन सर जी🙏

[@business-excel]

Great Brother 👍🎉

[@SurenderThakur-fl6re]

Aap job kha krte ho bhai

[@SurenderThakur-fl6re]

Kuch help chahiye aap se

[@showzab425]

Great yr

[@shahbazmemon6467]

Sir cash ledger ma asa hu sakta ha ka ham amount per click kren tou us ka bill copy bhi show hu

[@amanheer2698]

When you lock first column, then how come it picks up the next names value correctly? When I am locking column then all below values are I am getting same as i locked first column

[@smitamin5853]

he is giving distinct value by $ sign..

[@imransiddique1735]

Sir! I downloaded your file and add next sheet and used the formula of vlookup but didn't use any column reference in formula and all my data was same. Nothing happened. Please tell me why did you use column reference when we are getting the data exactly same?

[@usamaspeakscricket]

just to make it complex so people can buy his ebook

[@gopallaltailor7888]

Right ❤

[@BhaiHarshdeepSinghji]

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?

[@vipinpal215]

Yes

[@amnaghaffar7766]

Names ager duplicate hain OR id different hain or muje in duplicate ki id bhi same kerni hain means 1st id jo wahi baki duplicate id ki bhi hojai to kesy karey any one tell me

[@mrkhan11100]

You can do it by using ifs + AND formula =ifs(AND(select name cell = "replace with criteria name"),I'd number,AND(select name cell = "replace with criteria2 name"),I'd number,AND(select name cell = "replace with criteria3 name"),I'd number) [you can add more filed according to your requirements] then enter and drag it down.

[@Music_singer_Manbodhbanjare]

Sir mujhe formula lagane ke bad bhi na" Aata kya mistake hai bata sakte hai

[@pankajsharma4020]

Thnx for Nicely explaining…

[@uzmaikhlas4545]

sir aap kaun sa excel version use kar rahe hai Sir mein apna formula copy kar raha hoon mera excel mein yeh formula work nahi kar raha. Mera excel 2013 hai. =vlookup($A$2,'[Vlookup-for-Big-Data (1) PRACTICE FILE.xlsx]Data'!A$1:AF$229,column('[Vlookup-for-Big-Data (1) PRACTICE FILE.xlsx]Data'!$A:$A),0) App ke reply ka wait kar raha hoon

[@vlmtheloser]

Sir match ka formula kyu use nhi Kiya colum ka kyu use Kiya ??

[@Quran_thesolution]

Can we generate students annual report by using excel sheet in word document....character report basing on there performance in each subject

[@abroazhar]

vlookup and hlookup ko combine kar k kese lagaya jaye.. agar data lookup wala.. A1 to Z50 tak scattered hai... aur malooom na ho k jo hume search karna hai wo kis column aur kis row me hai?

[@Xkaran73x]

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

[@professor_skills320]

Very tough method 😔

[@kumarphulo]

Dear sir, My name is phulo kumar from bihar This formula is working on your data but it is not working my large data please help me

[@ashokgautam7438]

Really good stuff, thanks for sharing & updating our knowledge.

[@udaygupta9316]

Really helpful practice file ,thanks pls keep giving us such practice file so that we can practice nicely .Thank you sooo much .

[@AbdulJalil-id7gr]

not woeking at all in dragging downwards by using column(B1), here always coming the first value to the downwards cells of that column. update: it works when I used Columns(B1:C1) and without locking anything. [This works but this is not right way. ] I apologise, your method is right I was wrong, Thank you.

[@radhakantafriends9822]

Sir mujhe interest calculation karna hai.. Jaha Below 100000 k 4% and above 100000 k 5 % kaise formula lik chunga..

[@khokanali3655]

weekly collection microfinance par used karna ke liya ek excel par vedo bana deyjeya

[@noobplayergaming1093]

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

[@DilipKumar-ev1fy]

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

[@waqasahmed8698]

If the date contain multiple columns in other workbook unsequence and we want specific columns records. How can we fetch?

[@SeoExpert-zi6nk]

How to find maximum value from table aray ,BY VLOOK VALUE

[@VijendraloveSong]

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

[@PNmemesreactss]

sir maine ek data entry kiya hai. frst column box entry ka barcode or 2nd mai date hai, 3rd main scaning box entry hai. abhi prblm ye hai ki box entry or scaning box dono ka barcode alag alag date hain. abhi kese me entry box search kark scaning kab hua or scaning hua k nehi jan sakta hu ??

[@Mohammed_Ahmer]

I have 2,48,000 data in column A. How to do vlookup in this huge data?

[@mohdarhamqamar2928]

We can use xlookup function instead of vlookup....and this is more simple than vlookup

[@vishnuh4269]

Even without using Column function and locking I got the values without error, 👀

[@ashvingamad8271]

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

[@raone6923]

Use index and match , or x lookup, vlookup always have same problem for column number

[@santoshkumarmahto9842]

गुड मॉर्निंगसर मैं अगर आपसे क्लास लेना चाहूं तो कैसे ले सकते हैं क्लास का शुल्कक्या है

[@Technical_samachar]

Sir ek excel workbook me column name location different ho to fir us time kaise krenge .Because aapne jo example diya he usme dono workbook me column name same Same he aur sath hi sath one by one lagataar diya hua he magar kabhi kabhi aisa nhi hota he to Please bataye ya fir agr koi video is pr banaye he to uska link share kr dijiye

[@vardangogna]

Sir agr hamne empty row delete krni ho kitni sari kaise krenge mtlb ki 5 row ho jisme 3 row m 5-5 data hai or 1 row m 3 data ab mujhe bs ek row delete krni hai jo totally empty ho jis row m ek bhi data ho vo na delete ho kaise krenet

[@bubairoy5815]

Thank you Sir, but is formula me na 1 chota sa problem he. Wo he isse data source sheet me jaisa he exactly wasehe copy ho Raha he. Agar jaha me data fetch kar Raha hu waha heading ka position alag he or as per heading data aajaye to wo nahi ho raha

[@rohitpahwa510]

Thkww so much for such a valuable Insight. I copied the Excel and tried for practice but getting error,There are one or more circular references where a formula refers to its own cell either directly or indirectly.this might cause them to calculate indirectly. Try removing or changing these references or moving formula to diff cells. Ok button press krte h 0 result aata h Pl reply anyone

[@Moviekeeda1821]

Sir me chata hu ki janh bhi Excel sheet me Monday likhu usk aage automatically week off likha hua aa jaye. Aisa koi formula hai kya Excel me

[@kunallila7298]

Ye tab possible hai jab dono sheet mein column index same ho.... Alag alag column ho to kya hoga

[@shivanisheetalsapna8349]

Sir ek data me 500 log hai ek data me 300 log hai 300 vale data me dhoondhna h ki kon kon log 500 vale me se nhi hai please sir bta do

[@sky-high9123]

Highly appreciate it and highly recommended, very well explained extremely helpful thank u sir.

[@faisalnadeem5140]

Hi brother I Have one problem in excel please guide me I have two sheets one has teacher's name and other sheet which have data which teacher use which bus no so how I can sort out this

[@Fun.time90]

sir mere pas jo data woh alag hai woh mjhe youtube b koi b data nai mila . .worker ki sheet hai jis mai aik column mai 2 dibay hain yani 8 aur 0 . 8 duty hai aur zero ki jagah over time . . exec sheet mere ps ati hai jis mai name id aur overtime hota hai woh sara mai aik aik kar k dekh k likhta hon

[@NitinGupta-ko4fq]

sir vlookup formula tab to kam kar raha hai agar sheet alag hai but column no dono sheet me same position hai lekin agar sheet two me coloumn ki position alag hai supose sheet two me vlookup agar start hi g column se ho and sheet one me data a1 se hi ho tab kaise kare

[@sikandarismail1608]

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

[@nandishnandi8299]

Sir I couldn't copy formula in horizontal way

[@vamsikrishna8793]

Sir upon using this formula, dates being changed

[@shyammishrafanclub7996]

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

[@ahmadsufiyan4859]

Bhai mere pass esa formula hai sumfis sumproduct v lookup h lookup sab kuch ek mai ho kar dunga

[@abdulkarimansari4727]

Sir Iss data pr index match ka formula kaise lagega?

[@vinodkumarmaurya2893]

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

[@bhavneshparikh8283]

Can be possible client wise auto update loan amotozation table? Also if possible interest rate change so auto update automatic in excel Extra Payments means (Start at Payment No,Extra Payment,Payment Interval,Extra Annual Payment,Payment,Total Extra Payments) Additional Payment already showing in your video ,Variable or Fixed Rate ,Impact of interest rate HIKE on your loan EMI & repayment schedule & Impact of interest rate CUT on your loan EMI & repayment schedule ? how to create in excel & Suppose provide only interest

[@Adhikari345]

V lookup+ Match & X lookup use for thise data so will be solved

[@sujitmehta545]

Sir agar ye Excel ki file download karna ho practice k liye to kaha se karna padega

[@Abhisheksoni8738]

SIR LAW FIRM ME BHI EXCEL KA USE HOTA AUR KAISE DATA PAR USE HOTA HAI.ANY IDEA SIR JI

[@bhaviksolanki3683]

Sir muje Excel me vo formula chahi ye jo minit column me likha ho wo row me aromatic aa jaye

[@sparshgupta5245]

I sometime face error while applying vlookup my data gets arranged in ascending order Please help

[@GayanPapi]

Very Nice

[@sonalisharma220]

Thank you so much ye formula clear ho gya mera....bahut sare video dekhe pr apke video se clear hua doubt

[@CrynixTDM]

VLOOKUP , HLOOKUP - Bahut Important Formula hain yeh, Bahut Interview meh puchte hein ❤

[@vikramrajput2290]

but agar sir sabhi columns ki jagah bich bich me se koi column lena hai toh yeah usme apply nhi hota

[@SELFLEARNING-pb6fe]

VERY THANKFUL FOR MY JOB EXTRA INCOME

[@asishkarmakar974]

I have a problem. Can you help? I 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

[@hunnythegreat6481]

Sir I am in Dubai can u please help me out in this country. I am an Indian lady

[@mohamadafreedpasha8820]

Hlookup of large data how to do please that video also it help for how don't now this sir

[@Monikasharma43720]

laptop me f4 press kaise hoga sirrr mere laptop pr press krne ke baad b dollar sign nahi aara

[@santoshkundu9034]

Can you shares me how to vlookup value sigal entre showing in all rows

[@sushant5242]

Mera to Bina column lagaye aa raha hai, column laga raha hoon to galat ho jaa raha hai

[@ShailendraSahu-el1tl]

Sir please jese Items. Qty. A. 5. H. D. 8 K G T. 4 E Yese 50 items he jis me mene 10 ki entry ki to Me chahta hu ,jo me entry Karu wahi items name or qty. Print ho baki nahi. Sir please help

[@azharali1603]

Sir Jo apke formula bataya hain vo haar data main use kar sakte hain y sirf yahi sheet ky waste h

[@syedkamal8840]

Column formula is creating an error in vlookup?

[@santoshkumargupta8792]

Sir in my sheet column formula is not working

[@AbhishekPal-h2e]

Sir agar coloum nhi mismatch ha toh phir kaam nhi krta yeh vlook

[@user-vp2pu4dx3b]

Two sheets match kaise krtey h ...from base sheet se

[@barristow3269]

0:51 ye delete kaise kiya? Konsa keys use karna hota hai?

[@asifsiddiquidiy]

Sir Nazim ,I am from Karachi Pakistan your computer course are helpfull for my office work. Can join your computer couse

[@business-excel]

Yes you can join on my website techguruplus.com/excel-course

[@hemantray4179]

Agar mera starting column 2 na hoke 5 se start hote ha to kaise karna ha sir

[@ajay-I23]

Could you help me regarding this doubt I have 2 Excel files First file having 10 customers data (unique ID no., name Age, salary). Second file has 15 customers data (unique ID no., name Age, salary). But both files have 7 common customers. I want that, if my changes 1st file data (salary data) of some customer .The changes should be automatically updated in 2nd file for that customer. Example: If I change the salary of a person (in 1st file), then Excel should identify the unique ID no. (In 1st file) And after that Excel will automatically search this unique ID no. In 2nd file and after searching, Excel will update salary for that unique ID no.

[@santykashyap0]

Informative video sir 👍👍

[@skyyadav123]

2:51 Sir right drag karne pr bhi to vaulu aa rahi thi kya vase koi error tha

[@kingfighter08]

Hello sir I have Office Student and Home 2021 Does Ms Excel have all the features which required to learn for jobs

[@sameerkhan-ir8xf]

sir maine to fix nai kiya fir b nikal gya pura data drag karne se

[@khawajamuhammadadil4802]

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

[@Raju-rk5yx]

Freeze cell ko unfreeze karke kuch edit karna hai to kaise kare

[@souravechouhan4189]

Sir me apka ak subscriber hu bhut din se apke vedio dekh rha hu sir ak excel sheet he ushme kuch issue he or jo data mujay delet krna he ushke liye vedio avi tak kisi ne nhi bnaya yadi apki permission ho to me apko wo file send kru or jo mujay delet krna he wo issuse apk btau ushse hum Government wale 23000 logo ko help hogi hum logo ko kuch data 31 march ko update krna hota he pls sir help me