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

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

सर ये offset office 2010 में चलेगा?

Sir how to fetch data more than 1 worksheet or workbook in 1 vlookup formula.

Exllent 👍

❤ please make video pagebreak total dynamic

Order ID Sales Rep Region Product Price Remarks
1011 Mahesh East Oppo 12000 Yes
1021 Suresh West Vivo 17000 No
1031 Anshu North Samsung 22000 Yes
1041 Rashi South Nokia 27000 Yes
1051 Dinesh East Oppo 32000 No
1061 Mahima West Vivo 37000 No
1071 Manoj North Samsung 42000 Yes
1081 Mayank South Nokia 47000 No

Formula - =VLOOKUP($D$2,OFFSET($N$1,1,0,COUNTA($N:$N),COUNTA(2:2)),COLUMNS($D$1:E1),0)
Output - Order ID Sales Rep Region Product Price Remarks
1011 0 0 0 0 0

Please help me to figure out this

Tough formula he

Does it have the potential to take up table space?
In Vlookup Case
If Yes Please Clear Difference and Importance of both formulas

Thanks sir

Mr. Innozant Please answer my below Questions ??? still no answer from yr side ???

Hello sir good night sir

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

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.

why this complication when you can simply convert the data to tables?

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

Sir you are a very good sir..

Sir can get your all the videos in sequence..like part 1'2 ,3...

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

Tussi great ho,

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

Jay ho

ye to bot tough sb khichdi bna di

❤

Very good. Thanks!!

Sir क्या यह left में जा कर results को dynamicaly ढूंढ सकता हूं ?

thanks mujy 12 month k data ho present karna hy, main jis month ka name lekhon us ka data aajaye dosri sheet par.
please koi formula bata dain ye kese hoga. 🙏 thanks

Dear sir, I have a small question.. Can we find multiple matches from match formula? Not just one I need all occurrences

Nyc very well explained.
Could we make dynamic only offset position.

Sir formula lgane ke bad name hi copy ho rha hai

Sir, please upload video of monthly production report automatically 🙏

SIR.. GOOGLE SHEETS ME CHAHTA HU KI NUMBER UTNE HI US CELL ME AAYE JITNA DIGIT CHAAHTA HU.. AGR NUMBER KO LIKHU TO UTNA HI DIGIT AAYE.. NHI TO ACCEPT NHI KARE.. ISKE UPER PLEASE 1 VIDEO BANA DIJIYE.. THANK YOU SIR

Aap bohut ache se samjhate ho

Sir Formula use karake dekha maine lakin date ki jagah number aa raha hain to kya karu

Sir, D4:Z9999 table range ho to kaise rahega ? Auto daynemic hoga only vlookup no counta

Vlookup use kare data update kar sakte hai???? Please reply

Good source

Sir, मुझे daily बीस लोगों को एक ही format पर अलग अलग सबका data मिलता है, उस मिले हुए अलग अलग Excel file को mail से download karta हूँ फ़िर एक एक करके सबके data को उनके file से मेरे पास पड़े हुए same excel format वाली file मे paste karta हूँ, उसे consolidate करके, उस पर पहले से लगाए गए Pivot table रिपोर्ट में जाकर data source select करके refresh करते हैं और उसी file में side मे उसमे से कुछ rows columns copy paste एक एक करके रोज़ करना पड़ता है, इसमे मुझे आधा घंटा lag जाता है, मेरे मैनेजर और senior कहते हैं consolidate के बाद सिर्फ पाँच मिनट में रिपोर्ट refresh हो जाएगा, खुद को improve करो, सर मैं चाहता हूं कि यह सारा process macro से रिकॉर्ड कर लूँ, मेरा काम fast and easy हो जाएगा, सर मुझे आपकी मदद चाहिए l Please help me sir कैसे आप से connect हो, कोई Mail id phone call number please मुझे आपसे एक बार बात करनी है please, मार्गदर्शन करें l आपसे बहुत उम्मीद लगी हुई है कृपया मार्गदर्शन करे l मुझे आपकी Revert का इंतज़ार रहेगा l शुक्रिया.... आपका दोस्त Arun Kumar Singh Ballia UP
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

Thank You So Much Boss.

Great

very Useful formula. Thanks for sharing.

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

Sir how to use vlookup if sales rep data is in cell g3, price in i3 , product in e3.
I don't want to relocate any data

Sir I have apply same formula in same data but answer show 0, Total formula match with your formula, But I have selected the offset formula and Press F9 and then Press enter. Then Answer is Correct. but direct press enter answer shows 0.Why?

Great 👍

I Love the way u explained

Very good sir from pakistan need if error or sum if also plz

Hello sir ma nepal sa hu sir if multiple sheet ma party name ma different ha jaisa ke first sheet ma abc company pvt ltd ha or dusra sheet ma abc company private limited ha or dusra name ma yak ma name ka bach ma & or dusra sheet ma name ka bach and ha to yawala 2 years data different largest ha to kaisa vlookup lagaya

Super ji

Sir how we can use this function in large data. In other spreadsheet

Great sir very useful