i Applied VLOOKUP on 7000 Entries in Just 1 minute in Excel (New 2 Examples) Vlookup on Large Data
ฝัง
- เผยแพร่เมื่อ 3 ต.ค. 2024
- Download Practice File 👉 techguruplus.c...
Join Excel Course 👉 TechGuruPlus.c...
Cheque Printing Software 👉 chequeprint.in
How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
.
🔴 Facebook / techguruplus
🔴 Telegram t.me/TechGuruPlus
🔴 Instagram / nazim_excel
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
(1) Excel Videos • Top 20: Advanced Excel...
(2) Tally Videos • Email through Tally wi...
(3) Sponsored Videos • Edraw Max: Perfect Sof...
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
➟ Contact: nazim.khan09@gmail.com
➟ Website: www.TechGuruPl...
➟ Website: www.BijnorBusi...
#NazimExcel #AdvanceExcel #MISReport #DashboardReport
#ExcelCourse #LearnExcel #Exceltricks #Exceltips #BusinessExcel
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
![How To Apply INDEX and Match Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/tgqTGVB5lRk/mqdefault.jpg)
Download Practice File 👉 techguruplus.com/vlookup-on-large-excel-data/
Join Excel Course 👉 TechGuruPlus.com/excel-course
Cheque Printing Software 👉 chequeprint.in
Telegram 👉 t.me/TechGuruPlus
Sir mainey aapse hi sikha hai baday se baday file me ek hi formula me sara vlookup kse lagaye. Thanks sir. Aab mujhe koi bhi kitna bhi bada se bada data hi kyu na de de 30sec ke andar sara vlookup laga dunga.
Very nice explanation, the way you make us understand is really commendable.
One suggestion here is that you can use the match function instead of row and column to make it more interesting for end user.
Very nice and useful, isee tarah ke videos ki jaroorat hai. Thanks !!
Lovely information 👌👌
Very nice ❤
Bhai superb👌
Sir column ki jagah Match ka use bhi kar sakte the na😊
Ha vo bhi good idea hai 👍 i will try
Super very good dear
@@CHATGPT-z4j Thanks
Nice Sir ji
Sir,if column index number in not in serialwize increasing Ex. we need data from column (4,3,7,8,5)
then type {4,3,7,8,5},0)
sir hlookup pe v aise hi ek video bnao.
How to match positive and negetive number in Excel.?
Sir iske saath indirect formula kaise apply kare
Sir protected Excell sheet me बिना unprotect किए row और कॉलम को delete केसे करे कोई फॉर्मूला है या vba के मध्यम से
Sir GSTR2B KA DATA AGAR rate ke according COLUMNER purchase register mein banana ho to KAISE banaye
just wanted to tell you that I cracked an interview after watching and applying your instructions. Thankyou 😊
कर्सर को जहां तथा लेजाते रहते हो गलत गलत सेल में क्लिक करते रहते हो गलत गलत सेल्स को सिलेक्ट करते रहते हो.. ये सब से समझने में कठिनाई होता है कि आप किस सेल के बारे में बोल रहे क्योंकि क्लिक कहीं और करते रहते हो।
Sir bhut accha class but mere se ctrl+D krne pr same data copy ho rha please tell😢😢😢
not able to select source file while applying create dropdown list in company name in sheet4 in practice file any specific reason where i am wrong please help me on this.
Great work. thanks for this free stuff, really appreciate
Sir i want to learn advance excel if you can
Sure Sir, you can ask me on call 9536250020 about the course
Assalam alaikum Sir mujhy excel course krna hau me Pakistan sy hu ap teach kr skta
Hello sir aap kisi bich me vlookup lgake video bnaiye bahut confusion hota hai
Thank you so much sir😊
Jab mene ise try kiya to value me 0 a gya koi help kr do
row mei n/a aa raha hai
In your website; where i used "Special character Emoji Remove" option, I need to put excel but there is no option over there
RESPECTED SIR JAB HUM 8:15 PAR CTRL R AND D PRESS KARTE HAI TB TABLE TO FIL HO JATI HAI BUT SAME DATA COPY HO JATA HAI SARI CELLS ME PLZ BTAIYE
Mere sath bhi yahi ho raha h
Lookup cell me pblm aayi hogi@@LALITKUMAR-xc2zh
Sir , slicer ka bhi sikha dijiye excel Mai
How to sort multiple rows with the same company name with different revenue. ?
Informative video sir ♥️👍
❤Sir very useful information ❤❤
Mujhe lag nehi
Sir esa koi bot ya software bataye jaha apke bataye hue tarike se jab hum email nikalte hai uske badd email marketing as automation work kare or hum affiliate ke jariye income kar paye... Thanks in advance 🙂...
practise file is not downloading
Sir please make a video on 26AS reconciliation under excel with tds receivable in books of A/cs
Sir mera dada sirf horizontal me hi fill ho rhaa h jab me vertical dreg kr rha hu tho N/A aara h tho sir muje formula me glti hori h muje btaoo plzz jesa ap kre ho wese hi kraa hu but formula shirf horizontal hi dond pa rhaa h vertical nhi
Hi sir,
Sir agar isi data me daily bases pe muje different dates ka data lena ho kese aye ga mean k ap k pas ye 1 jan se 30 june tk 6 month ka data he to muje is me sir 15 feb se 15 march ya 20 april se 10 may tk chahye ho kese aye ga. Isi data me solution update kar de sir,
Mene formula lagaya fir niche drag Kiya to same nahi aaya balki wohi amount aayi what to do
very nicely explained, got subscribed your channel for more updates, thanks for making.
Thanks buddy
Vlookup ka masla sir multiple sheet mein hein buhat se logon ko nhi pata sir is pr zara ghor karein sir
Sir i get green flag
download file and check formula
Try FN+F4
Bahut bhadiya sir ji
So much informative content bhai🤞
thank you so much for this informative video
Sir multiple sheet mein kaisy lagogy sum k sath summary banana k lye
Beautiful......
Thanks u sir
Sir क्या आप ispe एक वीडियो बना सकते हो ❓❓👇👇
मै excel मे gst return file बनाता हूं जिसमें पार्टी का नाम, gst nmbr, bill nmbr, total amt और cgst, sgst igst के अलग अलग colum बनाता हूं
तो मैं चाहता हूं कि मैं जब भी amount डालूँ तो GST नंबर (state wise) के hisaab से अपने आप CGST, SGST, या IGST calculate हो जाए
मै बना दूँगा vedio 😂
Superb
very interesting video
sir define name bhi use kar sakate hai na bade data ke lie...
sir plz ans zrur dia ga ap k teach krna ka andaz bht acha smj arh
❤❤❤❤❤❤❤❤❤Thank You So Much Sir
Very useful video
Mujh phli bar samj ai vlookup ki thank you Soo much
VIDEO 20 MINUTES K HA AUR SEKHO 1 MINT MAI..
WAAH PANDY G WAAH
Dear explain krne me to time lagta hi hai, but Vlooup apply krne me 1 minute hi lagta hai
@@business-excel HAHAHA JUST KIDING SIR, AGAR 20 MINUTES MAI BHI SEEK LIA TU BHT ACHA HOGA..
Thank you so much for sharing.. 💫
Dikhaiye nhi deta
Change setting to 1080p in your youtube
hi sir jab main vlookup use krte hain to F4 se $ nhi ata hai plz suggest
Same😢
Same
FN button press karke f4 press kijiye
In laptop press fn key
Aap laptop use kr rahe ho to keyboard FN key hoga .. Dono keys (FN+F4) sath mein press karo
Thankyou so much sir first time vlookup itne ache smjh aayyaa
Very very thankyou
Wlcm , Stay connected
Sir kya aapne index or match function prr video nhii bnayi hh@@business-excel
Thank you sir from Kuwait 🇰🇼 ❤
Thanks 🙏
Hello sir bulk email gamil kaise create kare with password
brother bulk gmail nahi create hota, gmail don’t allow
👌😍🔥
❤❤❤❤
Nice bhai❤
Awesome brother, best video Mila ab tak ka
Thanks ✌️
11:13 par data validation karneke liye dusre sheet par click nhi ho pa rha hai plz reply kare sir ji
Ok i have explained in this vdo
th-cam.com/video/UMIp1GkcTcQ/w-d-xo.html
@@business-excel very very thanks sir god bless you
Is this video part of your course
Course videos are different than TH-cam videos
@@business-excelsir, Are you provide certificate, if we doing the course?
Your mail id sir