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.
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 🙂...
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,
I have one data sheet 1 that contains the one numbers/Name repeat with different values/Qty in one Excel sheet . In another Excel sheet 2 only numbers/Name mention. When I use vlookup formula in sheet 2 from sheet 1 only first value repeated against all Name/numbers How to solve this error
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.
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 हो जाए
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
कर्सर को जहां तथा लेजाते रहते हो गलत गलत सेल में क्लिक करते रहते हो गलत गलत सेल्स को सिलेक्ट करते रहते हो.. ये सब से समझने में कठिनाई होता है कि आप किस सेल के बारे में बोल रहे क्योंकि क्लिक कहीं और करते रहते हो।
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](http://i.ytimg.com/vi/U_pj0V5EOm4/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
just wanted to tell you that I cracked an interview after watching and applying your instructions. Thankyou 😊
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 !!
Awesome brother, best video Mila ab tak ka
Thanks ✌️
Great work. thanks for this free stuff, really appreciate
Sir GSTR2B KA DATA AGAR rate ke according COLUMNER purchase register mein banana ho to KAISE banaye
Bahut bhadiya sir ji
Mujh phli bar samj ai vlookup ki thank you Soo much
sir define name bhi use kar sakate hai na bade data ke lie...
❤Sir very useful information ❤❤
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
sir ek accountant excel ka kis tarikay say use kr skta hai vdio bna do plz
Thank you sir from Kuwait 🇰🇼 ❤
Thanks 🙏
Very nice ❤
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 🙂...
Thank you so much for sharing.. 💫
सर मेरी एक समस्या है मेरे पास 89 xml फाइल है जिसे मुझे एक साथ xls फाइल में कन्वर्ट करना है कृपया मार्गदर्शन करे
Bhai superb👌
Sir , slicer ka bhi sikha dijiye excel Mai
So much informative content bhai🤞
Sir column ki jagah Match ka use bhi kar sakte the na😊
Ha vo bhi good idea hai 👍 i will try
Sir multiple sheet mein kaisy lagogy sum k sath summary banana k lye
Sir protected Excell sheet me बिना unprotect किए row और कॉलम को delete केसे करे कोई फॉर्मूला है या vba के मध्यम से
very nicely explained, got subscribed your channel for more updates, thanks for making.
Thanks buddy
Thank you so much sir😊
sir plz ans zrur dia ga ap k teach krna ka andaz bht acha smj arh
sir hlookup pe v aise hi ek video bnao.
thank you so much for this informative video
Sir please make a video on 26AS reconciliation under excel with tds receivable in books of A/cs
In your website; where i used "Special character Emoji Remove" option, I need to put excel but there is no option over there
Lovely information 👌👌
Informative video sir ♥️👍
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)
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,
Sir iske saath indirect formula kaise apply kare
How to match positive and negetive number in Excel.?
I have one data sheet 1 that contains the one numbers/Name repeat with different values/Qty in one Excel sheet .
In another Excel sheet 2 only numbers/Name mention.
When I use vlookup formula in sheet 2 from sheet 1 only first value repeated against all Name/numbers
How to solve this error
Super very good dear
@@CHATGPT-z4j Thanks
Beautiful......
How to sort multiple rows with the same company name with different revenue. ?
Superb
❤❤❤❤❤❤❤❤❤Thank You So Much Sir
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.
Very useful video
Nice Sir ji
very interesting video
Nice bhai❤
Hello sir aap kisi bich me vlookup lgake video bnaiye bahut confusion hota hai
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 😂
Sir bhut accha class but mere se ctrl+D krne pr same data copy ho rha please tell😢😢😢
Assalam alaikum Sir mujhy excel course krna hau me Pakistan sy hu ap teach kr skta
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..
Same Formula but not working tried many times
Hello sir bulk email gamil kaise create kare with password
brother bulk gmail nahi create hota, gmail don’t allow
Thanks u sir
Sir i want to learn advance excel if you can
Sure Sir, you can ask me on call 9536250020 about the course
Try FN+F4
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 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
❤
Mene formula lagaya fir niche drag Kiya to same nahi aaya balki wohi amount aayi what to do
Vlookup ka masla sir multiple sheet mein hein buhat se logon ko nhi pata sir is pr zara ghor karein sir
Jab mene ise try kiya to value me 0 a gya koi help kr do
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
ruclips.net/video/UMIp1GkcTcQ/видео.html
@@business-excel very very thanks sir god bless you
practise file is not downloading
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
Tum bro lookup value wala cell pura fix kar rha ha isliye asya ho rah, tum ko lookup value wala cell ka ka khali pehle wala alphabet ko fix karna ha
row mei n/a aa raha hai
👌😍🔥
❤❤❤❤
Mujhe lag nehi
Sir i get green flag
download file and check formula
Dikhaiye nhi deta
Change setting to 1080p in your youtube
कर्सर को जहां तथा लेजाते रहते हो गलत गलत सेल में क्लिक करते रहते हो गलत गलत सेल्स को सिलेक्ट करते रहते हो.. ये सब से समझने में कठिनाई होता है कि आप किस सेल के बारे में बोल रहे क्योंकि क्लिक कहीं और करते रहते हो।
Is this video part of your course
Course videos are different than RUclips videos
@@business-excelsir, Are you provide certificate, if we doing the course?
Your mail id sir