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
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?
@@Innozant SIR u are very passionate about spreading Knowledge and even tho so Many other TH-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.. 💯🇮🇳🙏
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
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 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 🙏❤️
Amazing sir.
Bhut bariya.
I'm from pakistan.❤️❤️
Sir aapka ka learning availability bahut badhiya hai. Thank you 😊
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.♥️🙏🙂
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
Sir ji tu si great ho💕🔥
Excellent teaching Sir thanks 🇵🇰
Hi, I'm from bd. Actually i seen many videos but think your video is best.
Thanks dear..Keep learning
Great sir its really helpful
Thanks
Pure mind mein set ho gya hai.
Thanks dear . Practice jaroor karna
Sir aapka samjhane ka tarika bahut achha hai
Thanks Anuj
Thank you so much sir 😊
Thanks for teaching
Excellent teaching sir
Superb way to explanation
I am satisfied your teaching speech.
By umesh ray
Thanks Umesh Ji for your valuable appreciation
Excellent bro
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.
Excellent sir
Great concept sir
From kashmir
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
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 ?
Thank you sir.❤❤
U are genius
mind-blowing sir
1 number sir
Newly one learned today
You are great sir
Good part sir
you are best teacher ,👍🏻👍🏻👌🏻👌🏻🙏🙏☺
Thanks Man
Excellent
Awesome sir ji 👌
Thanks 💗
great sir, thanx
Sir mai to bangladesh se hun aur app bideo se bahut kuchh sikhunga..
Good..keep learning
Good explained sir
very great sir
Mast sir 👌👌👌👌👌👌👌👌👌
Nice and knowledgeable video
Thanks ❤️
Sir , do a video on summarising data and data entry sheet
Good
Amazing sir ji
Thanks Surinder Ji🙏❤️
EXCELLENT VIDEO
Thanks Mahaboob
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 🙏❤️
Excellent 👌
Thanks Jaspal Ji
lajwab
Thanks Bilal sahab❤️🙏
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
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
Sir pranam 🌹🌹
♥️🙏❤️
Thank you, sir
Thanks 👍❤️
सर जी 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 🙏
Superb videos Sir ...where I can find all videos.
Complete Videos tutorials are available in my youtubr channel
best
Thanks Devender
nice
Beautiful
Agar Different Emp.ID ke do logo ka same naam ho tab kya kiya jana chahiye?
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
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 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
v look up me rakha huwa name kaise dekhe sir ? 5:11 me
F9 press
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
how to get data from other sheet using vlookup and how get id with data validation list from multiple another sheets
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
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 :)
Sometimes new got to learn
Thanks Samat. Happy Learning 🙏♥️🙂
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
Sir. Ji😄😄😄😄
Thanks
ENTER SE AAPKA SWAGAT KARTE HAI 😀😀😂😂💯💯💯🇮🇳🇮🇳🇮🇳
😀❤️❤️❤️🙏🙏
@@Innozant SIR u are very passionate about spreading Knowledge and even tho so Many other TH-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 ❤️❤️
In example 1 if there is a duplicate name then how we will run this function?
Sir fee slip bananay kay leya help chaheya ta please how i contact with you
Wow Wow
What we similar names on table 2
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
This formula is not working on full name sir
Agar sir isi table mai 2 naam same ho to kese kaam karega
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
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...😊😊
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 my communication skills is low so could I get a better job ?
Work on your comm skills..it is very much required now..
Sir please explain xlookup in office 365 please sir please
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 😊
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
भाई इसे nested vlookup भी बोलते हैं?
Bilkul bolte hain dear
Wow
Thanks mahavir ji for your valuable feedback.Keep watching and share
How it is showing "Abhilash" instead of formula
How it is showing "abhilash"
Sir ek window se dusri window par vlookup kaise use kare
Ek window se dusre windonya excel workbook par?
Ye data kha se milaga sir
Already link diya hua hai video description me jaiye
🙏
Same name triple hoga to kaise vlookup kaam karega
👏👏👏👏👏👏👏👏👏👏
I have to ask a question
@innozantofficial telegram id.
Mara pass kuch products ha unka har packet ka alag alag serial number na or ma ya chta hu sirf quantity dalna sa utna serial number mjha mil jya
Jasa ki ha 10 mara pass pr chya sirf 4 ka serial number
Formula me answer kese show kr dete he ap
Select formula and use F9 to evaluate dear