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

[@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

[@Rivanshupalsawat8]

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

[@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

[@iCanMasti]

Really😮 यहां तो 9 से 10 हजार देके भी इतना गहराई से नही समझ पाया पर आपके एक video में इतना मैं समझ गया ऐसे ऐसे भी लोग होते जो education के नाम पे लोगो को लूट रहे है काश मै ये video कुछ महीने पहले देख लिया होता आपके यहां से ही मैं copmuter का full corce कर लेता मेरा टाइम बच जाता 😢 Thank you sir मैं laptop खरीद कर आपसे जरूर मैं ये excel का advance कोर्स करूंगा

[@ajaykumar-ul6wh]

I have more simple trick for this

[@samruddhi3612]

Please share your tricks​@@ajaykumar-ul6wh

[@sonalisharma220]

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

[@1rashidali]

Your are a best Teacher, main pichly 4, 5 saal sy Vlookup formula use kr raha hon, jesy mujhy kisi ny smjhaya tha laikn smjh aaj i, Love from Pakistan

[@business-excel]

Thanks

[@sundramdwivedi7300]

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

[@business-excel]

welcome

[@educated0519]

Awesome sir ji❤...Aap best teacher ho sir ji❤ek ek step aap ne samjhaya 🙏

[@business-excel]

Thanks for appreciating 🙏🍀

[@educated0519]

@@business-excel sir ji apko Dashera ki dher sari subhkamnaye🙏🙏

[@indreshbhardwaj5277]

Awesome bhout aacha se explain kiya sir Aap na...😊

[@ajaysharmaDistrictShamli.]

Thank you sir..Mera bahut bda problem solved ho gya aapki vajah se....aapka ❤ se dhanyawad.

[@IqraSafder-f7c]

boht sari videos h lookup cy related but jo apna smjhaya h na sir hatsoff

[@MuhammadImran-ty9mo]

I am from Pakistan and very thanks for your easy understandable video of Vlookup

[@shubhamshahu1682]

Thank you so much sir aapka tarika bahoot easy to learn hai first time aapka video dekha big fann..❤😊

[@VijendraloveSong]

Mene kitne video dekhe ES k liye par samjh nahi ayya Aap ne bohot badiya tarike s samjya . 👍

[@mynandahatech]

Thank you Sir So Much . सर मै आफका विडियो देखत रहेता हु और एक्सेल मे बहुत जानकारी लि है काम कर्नेमे सफलता मिलि है ।

[@CreativeClub23]

the best explanation of vlookup in the most simplest way, all the best Sir..

[@udaygupta9316]

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

[@laptopgharpatnabihar1637]

Bahut achche se app ne explain kiye hai vlookup ke bare me thanks sir❤

[@SanketTechSupport]

Thank you sr VLOOKUP formula btaya aapne bhut help mila thanks

[@godisgreat6474]

Thank you so much for the video 🙏🙏 Please keep posting critical excel solutions ❤❤

[@educated0519]

Thank you so much sir aap ne confusion dur ki....❤.....aap ne easy way bataya😍

[@user-ik8jp1tt4o]

best one is 6.48 sec... seems like you are matured content creator...how did i missed you on youtube...

[@business-excel]

Thanks buddy

[@sajedabegum2204]

Thank You very so much sir, after struggling for a very long time i successuffly complete vlookup. Your this tutorial is just superb to learn

[@business-excel]

@@sajedabegum2204 Great 👍

[@sky-high9123]

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

[@Quran_thesolution]

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

[@m.i.sco-ordinator9592]

Thanks a Lot.. Bahut Vadiya kaam kiya

[@sandeeplowanshi9]

बहुत बहुत आभार sir आपका

[@ashokgautam7438]

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

[@dmobanaskantha8685]

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

[@gauravnainwal3239]

I did it with using vlookup match and hlookup match both ways.....thankyou for your trick also

[@khushdilinsaan3605]

Nic sir bahut badhiya..🙏🙏🙏

[@abhimanyusinghrajput8039]

Thank you soooo much sir mai bahut dino se ye try kar raha tha nllekin mujhe samajh me hi nahi aa raha tha aap ka ye video dekh kar samajh me aa gya

[@business-excel]

Your most welcome 🙏

[@alindsrivastav6047]

It's very important video

[@Hotnews1111]

THANK YOU SO MUCH SIR LOTS OF LOVE FROM NEPAL

[@business-excel]

Thanks you too

[@advaitanarula7670]

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

[@business-excel]

🙏🙏

[@Matirp_8]

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

[@thetechtipps]

You are Great sir🙏

[@santykashyap0]

Informative video sir 👍👍

[@dharmendersingh2637]

this is the best way of learn very nice sir

[@Santosh-o1j5x]

Sir Dil se thanku very very nice video Dil se shukriya

[@imranahmed5348]

Thank u brother it's really helpful for me. Imran Ahmed from Pakistan.

[@SD-hf6ee]

Pakistan me bhi excel use krte hai????? Bomb spot krne ke liye thikane dundh ne ke liye kya

[@devanish117]

Thank you for saving my job and izzat ❤️

[@CrynixTDM]

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

[@SandeepSharma-ym2um]

Very valuable formula. Thanks 🙏 so much.

[@sardaransari1430]

Sir mujhe thoda bhi nahi aa rha tha but ab samjh me aa gya

[@debabratabiswas1193]

Well explained 👍

[@shivasharanandewadi9180]

Thanks for explaining in simple

[@ChetnaChauhan-hp1jy]

M itni der se try kar rahi thi ab hua h 🥰

[@business-excel]

@@ChetnaChauhan-hp1jy Great

[@GayanPapi]

Very Nice

[@rajubhardwaj9283]

Nice video sir ❤

[@scorpionvenom09]

Very well explained great 👍🏿

[@business-excel]

Thanks

[@kanhaiyachoudhary4833]

Thank you , helpful practice file 💯

[@Soumik2025]

Excellent job sir

[@Komal-we9iw]

Sir mera ek question h kya aap bata denge.....एक्सेल में VLOOKUP फ़ंक्शन का इस्तेमाल करके, पुराने डेटा में से नए डेटा में पुराने लोगों के नाम ढूंढे जा सकते हैं:

[@Kamal.kushwaha123]

तुम्हारे कहने का मतलब ये है कि तुम्हारे पास नए डेटा का नाम भी है और पुराने डेटा में जिन लोगों के नाम थे वो भी नए डेटा में शामिल है But तुमको नए डेटा में से पुराने लोगों के नाम छाटने है क्या यही है तुम्हारा question

[@thakurvirat6424]

​@@Kamal.kushwaha123ha

[@AshishSharma-lz7dl]

​@@Kamal.kushwaha123Kindly help to get latest data from file. Example Material "123" buy from vendor A, B, C and we have to get data of material purchase from latest vendor

[@realdrifters3161]

han bhai same problem​@@Kamal.kushwaha123

[@Santosh-o1j5x]

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

[@abdulmoid]

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

[@learncomputereducation]

Best sir and good understanding way of excel knowledge 🙏

[@user-kh7ju7gz6x]

Great video sir

[@HiteshTrivedi-x2p]

Bhai you are doing very good job thanks for such video this is realy helpfull.

[@business-excel]

Thanks Hitesh ji

[@FitnessRaj211]

WOOOOOOO. THANK YOU SIR

[@karangupta8005]

Match Formula sey bhi ho skta h kya yeh.....output same ayega....?

[@SameerShaikh-sc2kz]

Thanks bro... Simple and good

[@Yogeshkandy]

❤ Thank you so much

[@Scientificgamerz29844]

VERY GOOD , U R EXELLENT , THANKS

[@rangaswamyk3095]

Excellent teaching bro 👌

[@Sravanvlogzz]

Hi sir, The vlook function is cleared up and im getting some confusion in “$” symbol so i want to get more clear vision on it how do i ?

[@Sravanvlogzz]

And another doubt sir in the given sheet without freezeing the cell also im getting the values over the sheet,can i know the logic or reason beyond it ???

[@pbxkaaliii]

Looking that from years Thanks alot

[@business-excel]

Wlcm Naveen bhai

[@pratibhasudarshani8840]

Thank you, sir. it's really help for me.

[@business-excel]

Glad to hear that

[@MohitSingh-bn9qv]

Thanku so much for the much needed help🙏

[@SantoshPatel-vu7xl]

धन्यवाद सर जी

[@kailasjanerao3073]

Thank you sir j So greatful to you

[@showzab425]

Great yr

[@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

[@balveerrathore1087]

Bahut badiya

[@TheHimanshushah37]

Always Awesome

[@candlesolio]

Very helpful.

[@Md.NafisSalehKhan]

Great👍

[@abhayrijeans]

Sir koi large data pe forecasting report ka video bna dijiyega qki mere se ye interview main pucha gya tha pls

[@business-excel]

ok brother i will try

[@MukaaramSadiq]

Really helpful file.thank you soo much.

[@skyyadav123]

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

[@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..

[@sultanmirza8560]

really help full sir

[@arshadalisiddiqui5649]

Sir without formula multiple values ko copy paste kar sakte hai

[@falaksam8465]

Nahi

[@ravi1527]

Sir ji very nice 👌

[@simransingh8042]

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

[@nimishbhardwaj2121]

Thanks for taking it so efficient manner

[@kiranmore1733]

Awesome 👌

[@SeemaSharma-lj3cf]

Very nice 👍

[@safipanja1128]

Thank you so much, it will help me

[@kingfighter08]

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

[@laraibtariq1970]

bhai two excel sheets k full data ko vlookup say kesy comapre karna ha ..please is per video banain ..i need it

[@MuhammadTanveer-9797]

Very nice thank you❤

[@thetechtipps]

Wonderfull Sir ji

[@TeluguBashaShow]

Very nice explanation

[@business-excel]

Thanks

[@AlimKhan-bl5sh]

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

[@bhaveshbaghele5745]

Can we use match function to fetch column number

[@khokanali3655]

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

[@chandrakantamale2473]

Thank you sir ✨

[@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 ❤

[@dugendranishad4583]

Thanks so much sir

[@sourabhbajpai3003]

Perfect sir

[@nandanmishra9174]

Thank You Sir, Please Basic To Advance Excel Video Upload