Dynamic Vlookup in Excel | Make a Dynamically updated Vlookup Table in Excel using OFFSET Function
Вставка
- Опубліковано 6 січ 2021
- Dynamic Vlookup in Excel | Make a Dynamically updated Vlookup Table in Excel using OFFSET Function
Excel Lookup Functions- • Excel Lookup Functions...
Download the Assignment Master Practice Folder here (All Playlist Example at one place) drive.google.com/drive/folder...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.com/courses/adv-...
✅ Mastering Power BI Video Course
www.innozant.com/courses/powe...
✅ Mastering VBA Video Course
www.innozant.com/courses/vba-...
✅ Mastering SQL Video Course
www.innozant.com/courses/orac...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozantinfotech
#dynamicvlookup #offsetfunction#Innozant #dynamicoffset#vlookupoffset
I love you and explanation also
I watched your all mis video series step by step and having comleted this video series i attended only two interviews and both of them i falled in first one interview and the second one in passed so i have got a job that roll is HR MIS EXECUTIVE with MNC COMPANY WITH good salary . Thank you so much sir . I will learn a lot from your videos and gain knowledge to improve my skills sharply and growth my future .
❤❤
Congratulations dear...have a wonderful career ahead ♥️
Thanks for your valuable appreciation.
Thank you sir 💚💚
सिंपल एंड effective explanation श्रीमानजी ❤
सर आपका कोई भी तोड नही है काश स्कुल टाइम मे आप जैसे teacher मिले होते 🙏🙏🙏🙏
सर जब से आपसे जुड़ा हु आपके लगभग सभी वीडियो जो भी देख रहा हु अपने दोस्तो को भी शेयर कर रहा हु धन्यवाद सर इतने अच्छे वीडियो के लिए 🙏🙏🙏
Have to say with the patience you teach with every necessary detail from the scratch is very much appreciated. Because it's hard people having patience these days. That's what I love about this YT channel and I hope this will stay with this channel.
I am a senior citizen, I have nothing to do practically with all your excel videos still it is my hobby to learn the latest versions of excel, I take great interest in excel. Excellent, Sir, hats off to your way of explanation. While practicing your videos I , sometimes get confused with the process of freezing.
R. Mukherjee from WB.
بہت بہت خوب
سدا خوش رہے
Perfect. All perfect .Perfect teacher Perfect Method Perfect style .....wonderful !!!
Thanks Singh Sahab 🙏❤️❤️❤️
Sir, you are on of the great teacher ever, owsom sir
Love You Rohit..Hope you like this video..It's pure dynamic 🙏👍
@@Innozant sir App Columns ki jagah per Match Function v use kr sakte the na wo kafi asan V hota Hala ki ye V sahi hai.
Sir Maine is Match Function ke sath V ajmaya kafi asan Lga Muje Match Ke sath aur Ha Apne wo -3 ke bare me sahi kaha Wahi V Muje -1 use krna Pda jaisa apne btaya
@@Innozant Sir Ap Dependent dropdown List ko kaise Dynamic Bnaoge
Dear Sir You are one of the best Teacher.
Thanks Sir for support 🙏🙏
शुरू में तो लगा था कि टेबल में कन्वर्ट करेंगे।
पर आपने तो स्टेटिक डेटा को ही डाइनेमिक बना दिया।
ये बहुत ही बढ़िया वीडियो था विलूकअप के साथ ऑफसेट का, मजा आगया।
हा सर एक ओर बात आप अपना कीमती समय निकाल कर हमारे लिए वीडियो बनाते हैं ओर साथ ही साथ सभी के कमेंट का जवाब भी देते हैं। और सभी का हौसला भी बढ़ाते हैं। इसके लिए आपका बहुत बहुत धन्यवाद सर।
Thanks Tejpal...Aajke vieoe me Maja aa gya hoga..hope you enjoy this video..happy Learning 🙏❤️
The best teacher I ever saw on you tube. Your way of explanation is just superbbbbb.
Really means a lot today me..Never stop learning Swati..God bless You.❤️
True
Superb Sir, thank you for sharing your knowledge
Amazing formula sir aapko sach me best teacher ka award or youtube button milna chahiye
Thanks Mehta Ji❤️❤️❤️😊
आप बहुत अच्छा समझाते हो, धन्यवाद
Thanka Anil ji
This gentleman is wikipedia of excel. Great job!
Chand Lalit Ji.. Really Means a lot today me dear..Happy learning
Aap bohut ache se samjhate ho
I Love the way u explained
Sir you are best I have ever seen. A BIG THUMBS UP for you!
❤️❤️❤️🙏🙏🙏
I love this use of offset...….Thank you so much
Thanks dear
This Video Is Really Very Important. ❤️❤️❤️
❤️🙏♥️Thanks dear Pawan.
Very good tricks Sir, aap bhatee uniqe cheez sikhate he...thank you so much...👍👍👍
Owsam aj phr new formula sekha vlookup with offset kamal
Thanks dear❤️❤️❤️
Sir mein bahut lucky feel karta hoon aap Jaise teacher pakar aapko dekhkar lagta hai jaise problem name Ka toh koi word hi Nahin dictionary mein agar problem hai toh uska solutions bhi hota hai 🙏❤️ sir
Thanks Pawan Ji .God bless you dear ❤️
Simply Excellent. Thanks a lot.
Thanks Gopala Sir.. Happy Learning 🙏♥️
You are the out of the box....great work 👍
Thanks Reeshav ji❤️
Sir isme agar MATCH pass karenge to uske range ko bhi dynamic krna padega but ye jyada sahi rahega fully dynamic... Great video sir👍
very Useful formula. Thanks for sharing.
The way you explain is really awesome...thank you so much !!
Thanks Ravi Sahab ❤️
@@Innozant Thank you so much for such a fast reply...Eagerly waiting for your career guidance videos ...😊
@@Innozant Thank you so much for such a fast reply...Eagerly waiting for your career guidance videos ...😊
Thank you , you are great sir because super expert in excel with teaching techniques of everything in excel very good thank you again sir
Thanks Pramod Ji for such a valuable appreciation .. Really means a lot to me..🙏❤️
Thank you so so much for this Video 🙏🙏🙏 This is the best tutorial I came across so far for the Dynamic vlookup function. I have been following all your tutorials and have learned a lot. Hoping to learn more from you. 🙏🙂
Thanks Padmashree..We welcome you to experience the taste of success with Innozant -Seed of Success.
Recommend you to start your learning journey step by step(Playlist in sequence list are available in video description)
@@Innozant Also May I please request you to make a tutorial on Xlookup🙏
Offcousre..soon you may able to see complete office 365 videos.
@@Innozant Thank you very much ! Looking forward to that 😊
Bahut badhiya trick sir or bahut hi bariki se yani se to fal pakne tak,
Aisi hi amazing video stock maintenance, salary sheet, attandance sheet, expenses sheet, payment receipt cash bank report, basic to advanced level tak iski bahut need hai mujhe.
Haan Ye saare videos dheere dheer layenge dear ...Have patience .jitne bhi sheet maintain Karne hote Hain leke aayenge .time ke Saath
@@Innozant lagbhag is mahine mei aa jayege,
U r absolutely great sir, u r the king👑 of advance excel.
Thanks Souvik..Keep learning 👍❤️
Original teacher. Thanks
Thanks Manoj ji..Good morning.hv a great day
Thank you for sharing knowledge.
Thanks Aqeel Sahab 🙏❤️
Excellent presentation.
Sir you are the best teacher ❤️🔴
❤️🙏
Good explain sir👍
Thanks,☺️
मैंने इसे अलग से सेव्ह करके रख दिया है। बड़े काम आयेगा, थैंक्यू.
Very Good.. Thanks Dileep Mathulkar Ji❤️👍🙏
Great explanation sir 👑
ur rock sir, it's so amz....you r the best teacher.🙏🙏🙏🙏🙏
Thanks Harish Ji..God bless you..❤️
Fantastic, God Bless you sir
Thanks Salil. Happy Learning dear
Greatest formula 👍
Brother you are SuperStar Thank you 😊
EXCELLENT Information
Thanks Dear
Thanks Shahzad
This is one of the best question sir really love your video
Thanks dear
Good Job ..I learnt many things.. thank you
Thanks Veer
Thank you so much Sir...👌
😊
Itna pyaar interviewer vlookup se krte hai Aaj hme malum hua but due to ur dedication so many many thanks
Hahahaha.Thanks keep learning
Excellent 👌👍
Practice make man perfect 💪
Don't watch only just do practice..👍
👍❤️
Very nice explanation sir
Excellent sir..👍👍
Sir you are a very good sir..
I have really no words for you sir.
Thanks Arijeet ji❤️
Thank You So Much Boss.
Great.love it
Sir so great explanation of big function wow sir your teaching method
Thanks Jai❤️🙏
Very good. Thanks!!
Dear Sir,
Again great video and innovative thoughts. I have understood the topic very easily and quickly because of your OFFSET function series which I had watched every video sometimes earlier.
With warm Regards
Jayanta Bhattacharyya
Thanks Jayanta...Hope you like this vlookup dynamic video .. Happy Learning ❤️
Dil se thanks sir
Aapko bhi Shukriya Rizwan Sahab 🙏❤️
you are great teacher
❤️❤️ thanks
Excellent video. Thanks sir
Thanks Illyas Sahab. Happy Learning ❤️👍
You are great sir
Sir now I am watching your vedio. And I really enjoy it..Thank you for giving us and clear our concept regarding excel in such a easy way and in beautiful way..
Thanks dear
Very much & valued formula
Thanks Jay.. Happy Learning 🙏❤️
Sir!!! You are the bestest🫡❤️
You r great sir
Hey bro. Excellent way of teaching. Keep it up.
Thanks Deepu ,Happg Learning dear
Sir, I am learning a lot thorugh your videos
Thanks Mayur❤️
बहुत बढ़िया👌👌👌👌👌 👏👏👏👏👏👏👏
Thanks Nisha..Have a great day ahead
Bhai jan, excellant video, you are indeed a great teacher, salam hy aapko,
Thanks dear❤️
Great sir very useful
Excellent, it will be very usable
Thanks ❤️
Beautiful
Great Sir 👍
Super and
Dynamic concept
Thanks Rahul Ji.. Happy Learning 🙏❤️
Great teacher
Thanks Ankit Ji.. happy Learning ❤️👍
Super ji
Awesome ..sir
Mujh jaisi bandi bhi mahir hogai hai excel mein
Wow..M really Happy for you♥️👍
very superb sir
Thank you sir
I am from Bangladesh I saw many Vlookup Videos to absorb it but I did not get cleared from so...but your did❤❤stunning... Thanks.
Thanks dear...Keep learning
Sir you know the beauty of teaching and how to make its understandable too.. thank you so much 🙏🙏
Sir what's the difference in your paid recorded package and here on UA-cam?
thanks in advance 🙏.
Thanks Shagun..God bless You..Happy Learning ❤️👍
Paid Recorded cours is dedicated series (Class wise lecture are there -30 to 40 min length ) including power query and Power series + Live Doubt Session is there.
In youtube cours is also in sequencial manner from where you may learn and crack your interview easily .
Nice Sir, I like your every class
Thanks ❤️👍
Thanks from Pakistan..bro main learning lrhi hon or apko 3 rd video hai or i like your video
Keep learning.Keep growing
You are my mentor sir 💞
Thanks Abhishek Ji
Bahut useful video hai daily works ke liye. Aap humse rply karta hai sir so don't worry about that. 🙏🙏🙏
Thanks Satish Ji.. happy Learning ❤️👍
Exllent 👍
itna bada formula bna dete ho sir aap ki sab mine me gol gol ho jata hai😇😇
Gol gol ki wajah hai concept na clear hona..pehle scratch se seekhne phir ise attempt kren
Thanks you very much sir..............For This Video
Happy learning.. Thanks
Nice....sir.......
Great Sir G
Your new subcriber
Great 👍
So nice of you 👍
Thanks Yogesh Ji..GN..tc
Sir you are best 🙏🙏🙏🙏🙏🙏🙏
Thanks Gaurav Ji❤️👍
Super hero of excel
Thanks Raja
Great sir🙏🏻🙏🏻
Thanks Singh Sahab... happy Learning ❤️👍
Excellent video
Thanks Sadiq
GOOD JOB SIR
Amazing