Dynamic Vlookup in Excel | Make a Dynamically updated Vlookup Table in Excel using OFFSET Function

[@rahulram7273]

After watching your video only one thing comes to my mind. What do you eat? Let me answer before you think twice. You must eat excel.😂😁😂😁

[@Innozant]

Hahahaha..lovely 🤩

[@ManishVerma-gg8xl]

सर जब से आपसे जुड़ा हु आपके लगभग सभी वीडियो जो भी देख रहा हु अपने दोस्तो को भी शेयर कर रहा हु धन्यवाद सर इतने अच्छे वीडियो के लिए 🙏🙏🙏

[@RohitKumar-cc7zi]

Sir, you are on of the great teacher ever, owsom sir

[@Innozant]

Love You Rohit..Hope you like this video..It's pure dynamic 🙏👍

[@AvinashSingh-im4oc]

@@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.

[@AvinashSingh-im4oc]

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

[@AvinashSingh-im4oc]

@@Innozant Sir Ap Dependent dropdown List ko kaise Dynamic Bnaoge

[@rameshmukherjee871]

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.

[@zzzzz644]

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.

[@swatichauhan4835]

The best teacher I ever saw on you tube. Your way of explanation is just superbbbbb.

[@Innozant]

Really means a lot today me..Never stop learning Swati..God bless You.❤️

[@jaitiwari241]

True

[@devangmehta7087]

Amazing formula sir aapko sach me best teacher ka award or youtube button milna chahiye

[@Innozant]

Thanks Mehta Ji❤️❤️❤️😊

[@gurpalsingh1897]

Perfect. All perfect .Perfect teacher Perfect Method Perfect style .....wonderful !!!

[@Innozant]

Thanks Singh Sahab 🙏❤️❤️❤️

[@shivkumarshakya2280]

Dear Sir You are one of the best Teacher. Thanks Sir for support 🙏🙏

[@exceltech6012]

Itna pyaar interviewer vlookup se krte hai Aaj hme malum hua but due to ur dedication so many many thanks

[@Innozant]

Hahahaha.Thanks keep learning

[@AnuragSingh-w7g]

सिंपल एंड effective explanation श्रीमानजी ❤

[@choudhary2033]

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.

[@Innozant]

Haan Ye saare videos dheere dheer layenge dear ...Have patience .jitne bhi sheet maintain Karne hote Hain leke aayenge .time ke Saath

[@choudhary2033]

@@Innozant lagbhag is mahine mei aa jayege,

[@TIE-TakeItEasy]

This gentleman is wikipedia of excel. Great job!

[@Innozant]

Chand Lalit Ji.. Really Means a lot today me dear..Happy learning

[@eklachaalo]

Very good tricks Sir, aap bhatee uniqe cheez sikhate he...thank you so much...👍👍👍

[@AnisHaider-w4c]

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..

[@Innozant]

Thanks dear

[@priyanshidwivedi3983]

itna bada formula bna dete ho sir aap ki sab mine me gol gol ho jata hai😇😇

[@Innozant]

Gol gol ki wajah hai concept na clear hona..pehle scratch se seekhne phir ise attempt kren

[@tejpalsain1507]

शुरू में तो लगा था कि टेबल में कन्वर्ट करेंगे। पर आपने तो स्टेटिक डेटा को ही डाइनेमिक बना दिया। ये बहुत ही बढ़िया वीडियो था विलूकअप के साथ ऑफसेट का, मजा आगया। हा सर एक ओर बात आप अपना कीमती समय निकाल कर हमारे लिए वीडियो बनाते हैं ओर साथ ही साथ सभी के कमेंट का जवाब भी देते हैं। और सभी का हौसला भी बढ़ाते हैं। इसके लिए आपका बहुत बहुत धन्यवाद सर।

[@Innozant]

Thanks Tejpal...Aajke vieoe me Maja aa gya hoga..hope you enjoy this video..happy Learning 🙏❤️

[@imranali-iy5wk]

Owsam aj phr new formula sekha vlookup with offset kamal

[@Innozant]

Thanks dear❤️❤️❤️

[@iamsainipawan]

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

[@Innozant]

Thanks Pawan Ji .God bless you dear ❤️

[@firefmmotivation1367]

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 . ❤❤

[@Innozant]

Congratulations dear...have a wonderful career ahead ♥️ Thanks for your valuable appreciation.

[@firefmmotivation1367]

Thank you sir 💚💚

[@harishsingh2958]

ur rock sir, it's so amz....you r the best teacher.🙏🙏🙏🙏🙏

[@Innozant]

Thanks Harish Ji..God bless you..❤️

[@muhammadkhalil5712]

Excellent 👌👍 Practice make man perfect 💪 Don't watch only just do practice..👍

[@Innozant]

👍❤️

[@aamirmasood4655]

Bhai jan, excellant video, you are indeed a great teacher, salam hy aapko,

[@Innozant]

Thanks dear❤️

[@nishachauhan9103]

बहुत बढ़िया👌👌👌👌👌 👏👏👏👏👏👏👏

[@Innozant]

Thanks Nisha..Have a great day ahead

[@manojsable8482]

Original teacher. Thanks

[@Innozant]

Thanks Manoj ji..Good morning.hv a great day

[@pramodbhavsar4488]

Thank you , you are great sir because super expert in excel with teaching techniques of everything in excel very good thank you again sir

[@Innozant]

Thanks Pramod Ji for such a valuable appreciation .. Really means a lot to me..🙏❤️

[@satishojha6240]

Bahut useful video hai daily works ke liye. Aap humse rply karta hai sir so don't worry about that. 🙏🙏🙏

[@Innozant]

Thanks Satish Ji.. happy Learning ❤️👍

[@pawanverma7220]

This Video Is Really Very Important. ❤️❤️❤️

[@Innozant]

❤️🙏♥️Thanks dear Pawan.

[@nurulhuda4441]

Sir you are best I have ever seen. A BIG THUMBS UP for you!

[@Innozant]

❤️❤️❤️🙏🙏🙏

[@muhammadsaqlain5162]

Man is bat ka khud gawahi deta hon k ap her reply ka answer dete hai Sir, aj ki video to ap nay kamal hi ker diya hai bus itna kahunga k (Learn for Excel Only INNOZANT Channel 💯 👍.)

[@Innozant]

Thanks dear .mere liye ye hi fees hai ki aap life me aage badhen aur kuch behtar karen

[@muhammadsaqlain5162]

In Sha Allah Zaroor, man jab bhi apki video dekhta hon to mere dil se ap k liye yehi dua nikalti hai k Allah apko always dunya k dukh,dard,preshani,musibaton se door rakhen aur kamyabi khushyan ap k qadmo man ho, ap ek bohot achay teacher hi nhi hai balkay bohot achay insan bhi hai aur her mazhab yehi kehta hai k insaniyat se berh ker kuch nahi hai aur Allah nay ap k ander ye khubi di hai man sochta hon k apka shukriya ada kaise karun bus itna kahunga k zindgi man ager moqa mila to man ap se India zaroor milnay aionga, In Sha Allah.

[@souvikdas9110]

U r absolutely great sir, u r the king👑 of advance excel.

[@Innozant]

Thanks Souvik..Keep learning 👍❤️

[@tajumir48]

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.

[@Innozant]

Thanks dear...Keep learning

[@mayurjain2003]

Sir, I am learning a lot thorugh your videos

[@Innozant]

Thanks Mayur❤️

[@padmashreearahanth941]

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. 🙏🙂

[@Innozant]

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)

[@padmashreearahanth941]

@@Innozant Also May I please request you to make a tutorial on Xlookup🙏

[@Innozant]

Offcousre..soon you may able to see complete office 365 videos.

[@padmashreearahanth941]

@@Innozant Thank you very much ! Looking forward to that 😊

[@RaviShankar-de2yj]

The way you explain is really awesome...thank you so much !!

[@Innozant]

Thanks Ravi Sahab ❤️

[@RaviShankar-de2yj]

@@Innozant Thank you so much for such a fast reply...Eagerly waiting for your career guidance videos ...😊

[@RaviShankar-de2yj]

@@Innozant Thank you so much for such a fast reply...Eagerly waiting for your career guidance videos ...😊

[@RakeshSingh-qo5nd]

Sir isme agar MATCH pass karenge to uske range ko bhi dynamic krna padega but ye jyada sahi rahega fully dynamic... Great video sir👍

[@mishfaq9038]

بہت بہت خوب سدا خوش رہے

[@dileepmathulkar6516]

मैंने इसे अलग से सेव्ह करके रख दिया है। बड़े काम आयेगा, थैंक्यू.

[@Innozant]

Very Good.. Thanks Dileep Mathulkar Ji❤️👍🙏

[@aniljain2k]

आप बहुत अच्छा समझाते हो, धन्यवाद

[@Innozant]

Thanka Anil ji

[@muhammadshiraz2381]

I Love the way u explained

[@sunilsharmacricketgyan]

This is one of the best question sir really love your video

[@Innozant]

Thanks dear

[@MSKhan-xm2yt]

Thanks from Pakistan..bro main learning lrhi hon or apko 3 rd video hai or i like your video

[@Innozant]

Keep learning.Keep growing

[@sairaaslam3292]

Awesome ..sir Mujh jaisi bandi bhi mahir hogai hai excel mein

[@Innozant]

Wow..M really Happy for you♥️👍

[@shagunaggarwal5123]

Sir you know the beauty of teaching and how to make its understandable too.. thank you so much 🙏🙏

[@shagunaggarwal5123]

Sir what's the difference in your paid recorded package and here on KZbin? thanks in advance 🙏.

[@Innozant]

Thanks Shagun..God bless You..Happy Learning ❤️👍

[@Innozant]

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 .

[@jaynarayan1963]

Very much & valued formula

[@Innozant]

Thanks Jay.. Happy Learning 🙏❤️

[@Livestories2023]

Aap bohut ache se samjhate ho

[@reeshavpandey8158]

You are the out of the box....great work 👍

[@Innozant]

Thanks Reeshav ji❤️

[@Kingx7565]

Brother you are SuperStar Thank you 😊

[@jayantabhattacharyya628]

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

[@Innozant]

Thanks Jayanta...Hope you like this vlookup dynamic video .. Happy Learning ❤️

[@jaitiwari241]

You are the best tutorial provider for ms excel... Sir it's a request please start tutorial series on Power Bi

[@Innozant]

Soon m going to start Power series

[@jaitiwari241]

@@Innozant 🙏🙏🙏

[@jaitiwari241]

🙏🙏

[@gourangasamanta8636]

Sir you are the best teacher ❤️🔴

[@Innozant]

❤️🙏

[@ravikagrwa]

I love this use of offset...….Thank you so much

[@Innozant]

Thanks dear

[@pramodchandelpkc]

very Useful formula. Thanks for sharing.

[@arechb]

You are the great man.

[@jaiyadav1256]

Sir so great explanation of big function wow sir your teaching method

[@Innozant]

Thanks Jai❤️🙏

[@mohdwas86]

Great explanation sir 👑

[@arijeetkumarsharma226]

I have really no words for you sir.

[@Innozant]

Thanks Arijeet ji❤️

[@vaishavikolhe]

best explanation sir 👍

[@rupamsingh9787]

Sir!!! You are the bestest🫡❤️

[@deepushome3248]

Hey bro. Excellent way of teaching. Keep it up.

[@Innozant]

Thanks Deepu ,Happg Learning dear

[@karimsamnani3660]

Greatest formula 👍

[@AbhishekMishra-lh3jw]

Hloo sir actually may is video ko 2 hour's se find kr rha tha ...akhir ab mili hay ❤️😂

[@Innozant]

❤️❤️👍👍

[@AbhishekKumar-nb4et]

You are my mentor sir 💞

[@Innozant]

Thanks Abhishek Ji

[@myclass4006]

Nice Sir, I like your every class

[@Innozant]

Thanks ❤️👍

[@info2nactpty953]

you are great teacher

[@Innozant]

❤️❤️ thanks

[@situsahoo2482]

Sir aapke pitare mein kya kya nikal te hai .❤️.Superb sir.i love ur idology.hum toh soch liya aap use karenge Table.but hum ko offset aata hai.so this one hatke style dynamic .Love dilip sir.❤️ Sir Google sheet suru kijiye.🙏

[@Innozant]

Haha..sabko yahi laga ki table me convert karunga ..🙏❤️Haan Google sheets ke bhi Function karaunga ..krta hu start series Iska bhi .

[@devenderkumar1220]

Excellent sir..👍👍

[@Hari-n4f]

Excellent presentation.

[@ashishmehrotra7308]

Good explain sir👍 Thanks,☺️

[@booksforsuccess.5638]

Very nice explanation sir

[@AnisHaider-w4c]

Sir you are a very good sir..

[@gauravbhatia7987]

Sir you are best 🙏🙏🙏🙏🙏🙏🙏

[@Innozant]

Thanks Gaurav Ji❤️👍

[@veerkaku9448]

Good Job ..I learnt many things.. thank you

[@Innozant]

Thanks Veer

[@RahulKumar-xi7jq]

Sir ye think kaha se aata hai ke vlookup me offset function ka use karkai lookup range ko dynamic banana hai sir you are the best teacher in forever. Sir me kal tak kuch ne aata tha per jab se innozant chapal per video dekhne laga jab se mera confidence up ho gaya hai me ab accha kar raha hu sir Thanks sir give us this platform for success

[@Innozant]

Love you Rahul...Yahi chahta hu main aap sabse ki seekhne alni skills badhate aur life me aage badhen..Happy Learning 🙏❤️

[@localarts5095]

superb explainations!! Sir ek problem statement hai interview me pucha gya tha, thoda difficult lagta hai agr aap ek video bna de to help ho jategi, thank you so much Sir

[@Innozant]

Telegram kriye .time Mila to jarur bna denge vidoe

[@localarts5095]

@@Innozant okey Thank you Sir, But telegram me only admin send the msg bta rha hai. So I'm not able to send on the group.

[@mushutube83]

Thank you so much Sir...👌 😊

[@ranjitjojo]

Superb Sir, thank you for sharing your knowledge

[@brijeshshah574]

Bahut bahut dhanyvad Sirji 🔥👏🙏👌🙌🔥👏🙏👌🙌 Mafi ki jarurat nahi hai aap jo ye itna simple way me sikhata hai wohi bahut hai hamare liye. Agar aapko thik lage to ek to do list jaisa task bana dijiye jisme kisi ne question raise kiya ho to video k title k samne likh dijiye taki aap bhale der se solution leke aao per aapko pata rahe ki itna itna reply mene diya hai aur bakio ka reply dena abhi bhi baki hai. Just little suggestion from my side Sir. 😊

[@Innozant]

Thanks Brijesh Ji . Noted your query

[@1gopalakrishnarao]

Simply Excellent. Thanks a lot.

[@Innozant]

Thanks Gopala Sir.. Happy Learning 🙏♥️

[@amitapattanaik1071]

Fantastic, God Bless you sir

[@Innozant]

Thanks Salil. Happy Learning dear

[@rahulkumarsharma9533]

Super and Dynamic concept

[@Innozant]

Thanks Rahul Ji.. Happy Learning 🙏❤️

[@sunilvashist2903]

Great video sir

[@ManishVerma-gg8xl]

सर आपका कोई भी तोड नही है काश स्कुल टाइम मे आप जैसे teacher मिले होते 🙏🙏🙏🙏

[@mercynik2019]

Sir aap padhaoo or dout rahee jaeee ..... Impossible ❤️❤️❤️

[@Innozant]

😊😊😊❤️❤️❤️

[@saahilsaahil5912]

Just WoooooooooooooooooW Sir👌👌👌👌👌

[@Innozant]

Thanks Saahil..Happy Learning..❤️👍🙏

[@muzamiludaas]

Great Sir G Your new subcriber

[@balunigamer4483]

Great Sir 👍

[@Deepaksharma-rp6nn]

I think you are the best teacher for excel on you tube. U are great. I have some queries, I tried to connect on Instagram but u didn't reply 😒

[@Innozant]

Thanks Deepak Ji .Kindly connect us @innozantofficial telegram id

[@mdrubelhossain3494]

Thanks you very much sir..............For This Video

[@Innozant]

Happy learning.. Thanks

[@RMKserve]

Super hero of excel

[@Innozant]

Thanks Raja

[@shahzadsami5613]

EXCELLENT Information Thanks Dear

[@Innozant]

Thanks Shahzad

[@rizwanansari4294]

Dil se thanks sir

[@Innozant]

Aapko bhi Shukriya Rizwan Sahab 🙏❤️

[@exceltipsandtricksbyankitk4546]

Great teacher

[@Innozant]

Thanks Ankit Ji.. happy Learning ❤️👍

[@mohitnaudiyal1434]

Ek no .🤘🏻❤️

[@Innozant]

Thanks Mohit Ji 🙏❤️

[@sarojdas08]

Excellent, it will be very usable

[@Innozant]

Thanks ❤️

[@kishorpanara4191]

You r great sir

[@tapankumardas8252]

Great sir really awesome. Sir plz one video for dynamic xlookup function..

[@Innozant]

Office 365 ke saare Function with example leke aayenge video dear ..🙏❤️

[@sakibtalukder-6890]

Thank You So Much Boss.

[@indiansingh837]

Great sir🙏🏻🙏🏻

[@Innozant]

Thanks Singh Sahab... happy Learning ❤️👍

[@yogeshahire1823]

So nice of you 👍

[@Innozant]

Thanks Yogesh Ji..GN..tc