Sir your explanation is too good. I have one query as here you taught as nested Vlookup with the example of common value if we don't have any common value in multiple table then how to do it sir?
Sir Agar ye tables multiple workbooks per ho to same pattern per bhi kaam karega. Agar wo saree workbooks open kerke tab lagaya to kaam karega. All workbooks close kerne ke baad bhe work karega
@@Innozant SIR u are very passionate about spreading Knowledge and even tho so Many other UA-camrs are there such as Excel superstar etc,but Your way of Presentation and SENse Of Humour is Excellent And Different From Others...this makes Even A BORING topic Lively and Fun To Learn...Hats Off To Ur Work,Even In LockDown U Come With Smiling Face and We are Learning From You.. 💯🇮🇳🙏
Dear sir ji Jb kbi hm kisi bhi company ki per day attendance lgate h to new employee ki entry hoti h ab hme ye pta krna h ki kal jo attendance lgai or aj ki attendance me new employee ke name ke samne new entry likha aaye
sir agar different different employee id me name same ho toh phir double vlookup dusre data se result kaise laayega waha toh do same name me error aajyega na iska solution btaaiye?
Using duplicate vlookup dear..helper column leij using countif occurance nikalenge then vlookup apply. Already hai video iske uoar interview cracker series me dear
Sir mai interview me gyi thi wha pe unhone vlookup ka practical test liye jo mere se solve nhi hua..lekin mai us sheet ka pic le lithi mai aapko kaise share kru
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
Sir i am from Pakistan, I have learnt a lot from your channel. Bohat easy bhasha me aap samjhate hain.....
Thanks Ghulam.. Really means a lot to me..happy learning 🙏❤️
I faced this question at the time of interview....and now I got the exact answe (explanation )for that 😍😍😍
Thats Good.Ab Next Interview me galti nhi hoga..Learn Enhance skills and gey ready to face interview anytime.♥️🙏🙂
Amazing sir.
Bhut bariya.
I'm from pakistan.❤️❤️
Sir aapka ka learning availability bahut badhiya hai. Thank you 😊
Hats off to you absolutely easy way to make us understand
Keep Learning
very easily understood. Explanation is also very good sir. Thank you sir
Thanks Rahul
Keep learning 👍❤️
Sir really you are devoting great knowledge without any fee..... Thanks a lot.... And sir i want to meet you...
Thanks Tyagi ji
Excellent teaching Sir thanks 🇵🇰
Thanks for teaching
Sir aapka samjhane ka tarika bahut achha hai
Thanks Anuj
Great sir its really helpful
Thanks
Thank you so much sir 😊
Excellent bro
Hi, I'm from bd. Actually i seen many videos but think your video is best.
Thanks dear..Keep learning
Pure mind mein set ho gya hai.
Thanks dear . Practice jaroor karna
Sir ji tu si great ho💕🔥
I am satisfied your teaching speech.
By umesh ray
Thanks Umesh Ji for your valuable appreciation
Excellent sir
greeat explanation sir kiya baat hai aaap ki kash aaap ka center paksian m b hota
Koi baat nahi ..aapke liye videosa aa rhe hain na regular ..seekhiye aur life me aage badhiye dear
hi sir
you assignment mastr folder for practice is accessing for learn
your teaching mathod is superb
Yes..you may download it and start your practice.
Great concept sir
From kashmir
U are genius
Excellent teaching sir
1 number sir
Superb way to explanation
Newly one learned today
Sir mai to bangladesh se hun aur app bideo se bahut kuchh sikhunga..
Good..keep learning
mind-blowing sir
Thanks Man
Excellent
Thank you sir.❤❤
Good part sir
Sir your explanation is too good. I have one query as here you taught as nested Vlookup with the example of common value if we don't have any common value in multiple table then how to do it sir?
same doubt i have sir ? Please answer ?
You are great sir
Sir , do a video on summarising data and data entry sheet
great sir, thanx
Good explained sir
Good
you are best teacher ,👍🏻👍🏻👌🏻👌🏻🙏🙏☺
Awesome sir ji 👌
Thanks 💗
very great sir
Mast sir 👌👌👌👌👌👌👌👌👌
lajwab
Thanks Bilal sahab❤️🙏
Nice and knowledgeable video
Thanks ❤️
EXCELLENT VIDEO
Thanks Mahaboob
best
Thanks Devender
Guru ji Mujhe same value ko multiple table se lookup kraana h to kaise lookup kain
Sir multiple vlookup ko ek sheet se dusre sheet pr samjhayen
SIR MOST OF TIME I AM GETTING ERROR WHILE USING COLUMN OPTION IN VLOOK UP
BUT WHILE I AM USING COLUMNS , IT PERFECTLY WORKS
Wrong application kar rahe honge column function ka aap
Excellent 👌
Thanks Jaspal Ji
Thanx sir.....any idea abt power bi or sql. Aur sir pls offset ...
Videos are uploadjng iplaylist wise in sequence..Soon you may ablw to see these videos
Great Interpretation
Thanks Rajdeep 🙏❤️
Amazing sir ji
Thanks Surinder Ji🙏❤️
Sir pranam 🌹🌹
♥️🙏❤️
hi bro i have a huge data vlookup is not working for merge rows can you help how can i reach you
Sir
please do some interective dashboard video
Watch dashboard series
how to get data from other sheet using vlookup and how get id with data validation list from multiple another sheets
Agar Different Emp.ID ke do logo ka same naam ho tab kya kiya jana chahiye?
Thank you, sir
Thanks 👍❤️
❤️❤️❤️❤️
nice
Sir
Agar ye tables multiple workbooks per ho to same pattern per bhi kaam karega. Agar wo saree workbooks open kerke tab lagaya to kaam karega. All workbooks close kerne ke baad bhe work karega
Haan kyu nhi karega kaam..workbook clpse hone ke case me sumproduct is good
Wow Wow
Beautiful
2 alag alag sheet mera vlookup me #N/A ka eeror aata he ye error hatane ka 1 video banaiye sir
Sir table1 ka Name table2 se sequence me hona Zaroori hai
What we similar names on table 2
Superb videos Sir ...where I can find all videos.
Complete Videos tutorials are available in my youtubr channel
Sir please explain xlookup in office 365 please sir please
सर जी 5:11 पर आपने कोन सा शॉर्ट कट यूस किया था जिससे आभाष रिज़ल्ट शो किया है, प्लीज़ सर रिप्लाइ माइ संदेश।
Select karke F9 press karenge value dekhne ke liye
Phir wapis original state me aane ke liye Ctrl+z
@@Innozant thanks sir ji 🙏
Sometimes new got to learn
Thanks Samat. Happy Learning 🙏♥️🙂
ENTER SE AAPKA SWAGAT KARTE HAI 😀😀😂😂💯💯💯🇮🇳🇮🇳🇮🇳
😀❤️❤️❤️🙏🙏
@@Innozant SIR u are very passionate about spreading Knowledge and even tho so Many other UA-camrs are there such as Excel superstar etc,but Your way of Presentation and SENse Of Humour is Excellent And Different From Others...this makes Even A BORING topic Lively and Fun To Learn...Hats Off To Ur Work,Even In LockDown U Come With Smiling Face and We are Learning From You.. 💯🇮🇳🙏
Love you Varun..Aapke ye words mere liye truly bht mayne rakhte hain.Have a wonderful career ahead ❤️❤️
Sir kya hm esko index se kr skte hai?
Index se attempt kiya h apne?
@@Innozant ji sir kia
Index se name laya fir v lookup lagadia
Dear sir ji
Jb kbi hm kisi bhi company ki per day attendance lgate h to new employee ki entry hoti h ab hme ye pta krna h ki kal jo attendance lgai or aj ki attendance me new employee ke name ke samne new entry likha aaye
Sir fee slip bananay kay leya help chaheya ta please how i contact with you
In example 1 if there is a duplicate name then how we will run this function?
Sir aap jab Nested Vlookup likh rahe the that time aap ne kuchh karke wo formula me "Abhash" show karaya wo kaise kiya??
F9 press dear .. evaluate krne ke liye
Sir. Ji😄😄😄😄
Thanks
Agar sir isi table mai 2 naam same ho to kese kaam karega
sir agar different different employee id me name same ho toh phir double vlookup dusre data se result kaise laayega waha toh do same name me error aajyega na iska solution btaaiye?
Duplicate vlookup chaliye using countif usme
Thank you sir :)
Sir, Somproduct(--( wala formula or sikha do detailed explaine me. Please
Sumproduct ka playlist new launch hona hai.. complete sumproduct ke video wahan milenge dear keep watching.step by step seekhte rhiye.
Sumproduct ka video bht detail.me aana h wait kijiye kuch din
@@Innozant Thank you so much Sir...😊😊
🙏
v look up me rakha huwa name kaise dekhe sir ? 5:11 me
F9 press
Wow
Thanks mahavir ji for your valuable feedback.Keep watching and share
How it is showing "Abhilash" instead of formula
Double Vlookup formula me Formlua type karne ke bad kya "Ctrl+Enter" kare ya direct" Entre"kare
Simple enter ..Ctrl+ enter no need
press direct enter button after placing the lookup formula.
Sir I have some problem in Excel and I don't understand what formula use in my Excel sheet I totally confused please help me
Kindly ask your query or share @innozantofficial telegram id
6:01 ye konsi sheet shuru kr di ye to drive pr hai hi nhi.
Hai dear
@@Innozant kis naam se hai. double vlookup p to nhi hai
👏👏👏👏👏👏👏👏👏👏
This formula is not working on full name sir
👍
❤🙏
How it is showing "abhilash"
Bhai table me ek hi naam ke do employee hain to kaise nikalenge salary
Using duplicate vlookup dear..helper column leij using countif occurance nikalenge then vlookup apply.
Already hai video iske uoar interview cracker series me dear
Sir ek window se dusri window par vlookup kaise use kare
Ek window se dusre windonya excel workbook par?
Same name triple hoga to kaise vlookup kaam karega
आपकी आवाज अमित सयानी की तरह हे जो radio पे गीतमालिका मे आवाज देते हे
Ok .Maine suna nhi hai unhe.. Thanks ❤️❤️
🌟🌟🌟🌟🌟
Sir mai interview me gyi thi wha pe unhone vlookup ka practical test liye jo mere se solve nhi hua..lekin mai us sheet ka pic le lithi mai aapko kaise share kru
@innozantofficial telegram I'd par send kariye
Waise Aisa kya puch liya tha jo aapse nhi ho paaya VLOOKUP me 😊
भाई इसे nested vlookup भी बोलते हैं?
Bilkul bolte hain dear
Sir my communication skills is low so could I get a better job ?
Work on your comm skills..it is very much required now..