How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
HTML-код
- Опубликовано: 29 сен 2024
- 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
➟ nazim.khan09@gmail.com
➟ Website: www.TechGuruPl...
#Call_9536250020_to_Join_Advance_Excel_Course #TechGuruPlus #NazimKhan
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/
Sir simple vlookup formula se bhi ho rha sare values shi ayi A
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
I could send you a image if there is an option
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
2:47 sir मेरी एक sheet है usame date wise जेसे 1-2-2023 pir 1-3-2023 with number उसकी details bi aajaye
Really helpful practice file ,thanks pls keep giving us such practice file so that we can practice nicely .Thank you sooo much .
boht sari videos h lookup cy related but jo apna smjhaya h na sir hatsoff
Thank you Sir So Much . सर मै आफका विडियो देखत रहेता हु और एक्सेल मे बहुत जानकारी लि है काम कर्नेमे सफलता मिलि है ।
Highly appreciate it and highly recommended, very well explained extremely helpful thank u sir.
I did it with using vlookup match and hlookup match both ways.....thankyou for your trick also
Thanks for explaining in simple
Very valuable formula. Thanks 🙏 so much.
Thank You Sir,
Please Basic To Advance Excel Video Upload
Very Nice
Best sir and good understanding way of excel knowledge 🙏
Perfect sir
Very nice 👍
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.
Well explained 👍
Sir koi large data pe forecasting report ka video bna dijiyega qki mere se ye interview main pucha gya tha pls
ok brother i will try
Looking that from years
Thanks alot
Wlcm Naveen bhai
Thanku so much for the much needed help🙏
Thanks
Always Awesome
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.
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
Thank you so much for this video
Thank you sir ✨
Nice
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
Thank you... really helpful
SIR LAW FIRM ME BHI EXCEL KA USE HOTA AUR KAISE DATA PAR USE HOTA HAI.ANY IDEA SIR JI
Thanks Sir Ji 🙏
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
Ye tab possible hai jab dono sheet mein column index same ho.... Alag alag column ho to kya hoga
If the date contain multiple columns in other workbook unsequence and we want specific columns records. How can we fetch?
Sir muje Excel me vo formula chahi ye jo minit column me likha ho wo row me aromatic aa jaye
Thanks a lot sir exactly i needed this one
Bhai mere pass esa formula hai sumfis sumproduct v lookup h lookup sab kuch ek mai ho kar dunga
Nce grt job
🙏🙏
Table arrey ko lock krne ke liye kon si key ka use karna hai?
I am using excel 2021 , I did the same thing but the main table was in the same sheet but I never have to put dollar sign, just column number and did the copy paste formulae and got the desired results till 31st.
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!
Just Search on Google
"Say goodbye to Xlookup"
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, 😮
Thanks for suggesting dear
@@business-excel it's my pleasure sir ji 😊😊
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
sir kisi bhi excel sheet me bahut sare village diye gaye hai use hum kaise pata kare koin sa village kitne pracentage hai
How to find maximum value from table aray ,BY VLOOK VALUE
Match se bhi to ho sakta tha?
गुड मॉर्निंगसर मैं अगर आपसे क्लास लेना चाहूं तो कैसे ले सकते हैं क्लास का शुल्कक्या है
Freeze cell ko unfreeze karke kuch edit karna hai to kaise kare
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
Sir agar ye Excel ki file download karna ho practice k liye to kaha se karna padega
Vlookup with Match function se bhi Result mil jaega!!
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
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
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.
Hi sir, I need to buy ur classes. How to buy this?
ok you can call me on 9536250020
sir maine to fix nai kiya fir b nikal gya pura data drag karne se
how to use this same trick in xlookup?
when i press the f4 button the dollar sign is not coming can anyone please help me
Try with FN button, FN+F4 key
Duplicate karne se vi dekh sakte ho "Rohit Sharma" ki data
Thank you so much sir, सर मुझे ये कॉलम फंक्शन से आता था vlookup, लेकिन मैं जब कभी भी लगाता था थोड़ा सा कंफ्यूज हो जाता था, लेकिन आपने इतना आसानी से समझाया की जिंदगीभर के लिए दिमाग में बैठ गया। थैंक यू अगेन सर जी🙏
Great Brother 👍🎉
Aap job kha krte ho bhai
Kuch help chahiye aap se
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
he is giving distinct value by $ sign..
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
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.
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?
just to make it complex so people can buy his ebook
Right ❤
Sir mujhe formula lagane ke bad bhi na" Aata kya mistake hai bata sakte hai
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?
Yes
Sir mujhe interest calculation karna hai.. Jaha Below 100000 k 4% and above 100000 k 5 % kaise formula lik chunga..
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
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?
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
जब हम डाटा में फिल्टर लगाते है और हम चाहते है की हमने जो सेल्ड्ट किया है सिर्फ उस का टोटल नीचे दिखे
उसे के लिए तरीका दे सर
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 ??
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
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
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
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
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
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
Use index and match , or x lookup, vlookup always have same problem for column number
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
I have 2,48,000 data in column A. How to do vlookup in this huge data?
Even without using Column function and locking I got the values without error, 👀
We can use xlookup function instead of vlookup....and this is more simple than vlookup
Can we generate students annual report by using excel sheet in word document....character report basing on there performance in each subject
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
Sir match ka formula kyu use nhi Kiya colum ka kyu use Kiya ??
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
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
but agar sir sabhi columns ki jagah bich bich me se koi column lena hai toh yeah usme apply nhi hota
Really good stuff, thanks for sharing & updating our knowledge.
Very tough method 😔
Sir cash ledger ma asa hu sakta ha ka ham amount per click kren tou us ka bill copy bhi show hu
Sir Jo apke formula bataya hain vo haar data main use kar sakte hain y sirf yahi sheet ky waste h
Sir Nazim ,I am from Karachi Pakistan your computer course are helpfull for my office work. Can join your computer couse
Yes you can join on my website techguruplus.com/excel-course
But in my opinion to use this the column position in both the table has to be the same. right?
V lookup+ Match & X lookup use for thise data so will be solved
Sir I am in Dubai can u please help me out in this country. I am an Indian lady
laptop me f4 press kaise hoga sirrr mere laptop pr press krne ke baad b dollar sign nahi aara
Match Formula sey bhi ho skta h kya yeh.....output same ayega....?
Agar mera starting column 2 na hoke 5 se start hote ha to kaise karna ha sir
Hlookup of large data how to do please that video also it help for how don't now this sir
Can you shares me how to vlookup value sigal entre showing in all rows
Sir agar coloum nhi mismatch ha toh phir kaam nhi krta yeh vlook
Sir upon using this formula, dates being changed