Vlookup to Get Complete Record | Row , Rows | Lookup Full Record

[@hemantsingh9966]

You are not Sir... Because Sir teaches only... You are Guru... Why... Because, only Guru can give life to a non-living thing. Excel is a non-living thing. Guru ji... You are giving life excel. Whenever I saw your videos then my soul connects with the soul of excel. All it happens when your soul has only a purpose. That purpose is to connect the soul of learners and Excel.... Shastang pranam🙏🙏🙏 Guru ji.

[@Innozant]

Thanks for such a valuable appreciation dear.God Bless You..Happy learning..Have a wonderful career ahead❤️

[@hemantsingh9966]

@@Innozant Further...I got my education from good schools and universities. Hence, many highly qualified teacher taught me. I also learned some topics with the help of TH-cam. Essentially, I would like to say...I got many teachers in my life....but only limited Gurus in my life....And You are on of them...Guru ji.

[@zahoorsarbandi2982]

I am from Pakistan. I really appreciate your style of teaching and your knowledge.I have watched many videos on Excel.. But Innozant is the best. Well done sir

[@Innozant]

Thanks Zahoor for such a valuable appreciation. Happy learning

[@ebcy1591]

I thought one day will practice more but now I changed my mind , i will study for one hour everyday. Drop by drop fills the pot.
Thanks
Jai Hind
Kevyan.

[@Rjno1only1]

He is a wonderful Teacher, the best Teacher I have ever seen in my life. He explain with great heart and energy for the well being of the individual, I sincerely respect you.

[@shrikantbadge3978]

Truly teaching is an art. Bahut log sikhate hain lekin technique jo sabko samjhade is rare. Hats off Dipak Sir. Telling this after watching many videos before meeting Innozant channel.

[@Innozant]

Speechless...🙏❤️ Thanks for such a valuable and inspiring comment .👍🙏❤️

[@vishaltanwar8318]

Sir I really appreciate you 🙏🏻 apke concept bhot ache hai mera mind kaafi devlop ho rha aapke videos dekh kar 🙂

[@Innozant]

Thanks dear

[@sajidmollick1117]

This is the actual teaching ❤️❤️❤️❤️

[@Innozant]

Thanks dear❤️🙏

[@abhishekguleria1800]

Best Excel teaching provided on TH-cam. Thank you sir!!

[@Innozant]

Thanks Abhishek ji..Happy Learning ❤️

[@Taris376]

Aapki video se menu kafi cheeje sikhi hai
Abb meri office working kafi easy huyi hai
Thanks sir

[@tariqhussain1497]

Good morning, i am watching your excel series and i like that every practice you make available and your explanation is very nice and you never leave any small thing or big thing , but in a very simple way.

[@Innozant]

Thanks Tariq..Keep learning

[@7Rkcrickets]

Wonderful teaching style & concept sir ❤❤❤❤❤❤

[@dikshagupta5703]

So crystal clear concept explaining....God bless you sir.

[@Innozant]

Thanks Diksha for your valuable appreciation..Really means a lot to me.

[@ManojPatel-gp9kk]

Your content is better than any paid course

[@Innozant]

Thanks Manoj Ji.Really means a lot to me

[@rajatverma8164]

This trick must be useful for everyone who is work in excel on daily basis... thanku so much sir...❤

[@Innozant]

Thanks dear

[@bkdairyfarm6447]

Thank you sir love and respect from Pakistan.

[@vishwash2004]

Your teaching method is so Gr8....Pranam Guru ji...🙏🙏🙏🙏

[@Innozant]

Thanks dear

[@akak3585]

Thanks for video sirG

[@aishwaryaambasta7013]

Totally effective video sir..

[@abhishektiwari2643]

Yes 👍👍💓

[@sudiptamanna4195]

Sikhaneka tarkia bahut badiya sir..

[@Innozant]

Thanks Sudipta ❤️🙏

[@BalvirSingh-qs9kz]

Sir आप सबसे अलग इस भीड़ में। बहुत अच्छा। धन्यवाद

[@Innozant]

Thanks Balvir Ji.Happy Learning

[@asif-hussain585]

You have explained very well that those who became guides .

[@Innozant]

Thanks dear..Keep learning

[@umeshray3463]

Very good classes

[@BIMMCRT-]

Sir, i always use the jugaad way. now I understood the correct ways. Thank you.

[@Innozant]

Hahahaha..Ab jugaad ki jarurat NH hogi❤️❤️🙏

[@yuvrajkumar7104]

Best teaching

[@arjunaswal30]

Great channel for learning 👏👏

[@Innozant]

Thanks

[@aamirjilani5683]

very well defined 👍👍👍👍

[@VivekRaj-i3j]

Bahut Badhiya Sir

[@sdsbma]

you rocked such a excellent teaching style

[@Innozant]

Thanks Shoaib sahab

[@computerorigin7434]

Best excel trainer

[@Innozant]

Thanks.Really means a lot to me

[@nileshchakrabarty9605]

You r great Sir

[@dipsundardutta2735]

Excellent sir. ❤❤

[@asifkhurshid9208]

Great Professor...so kind and regard.

[@Innozant]

Thanks Asif Sahab

[@sonuansari3986]

Bahot khub sir ji

[@brijnarayan1234]

wah sir bohot khoob. kucch basic bate nahi pta thi ap ne clear kar diya. thankyou so much

[@Innozant]

Thanks Brij Narayan Ji... Happy Learning dear..seekhiye step by step

[@binaykumarnayak9114]

Thank you so much Sir

[@Innozant]

Thanks Vinay ❤️

[@balamira297]

Perfect videos for excel!

[@Innozant]

Thanks Mira❤️🙏We welcome you to experience the taste of success with innozant Seed or Success.
Recommended you to learn step by step from Basic to Advanced.

[@balamira297]

@@Innozant sure sir

[@brijeshshah574]

Bahut bahut dhanyavad Sir aapka 👏🙌🙏👌🔥

[@abhijitdey1819]

Very good explain sir. Thank you so much sir

[@shahzadsami5613]

Great information

[@Innozant]

❤❤🙏🙏

[@seerattandhan6807]

Very well explained...👍

[@sameerabanu3115]

best teacher

[@Innozant]

Thanks Sameena ❤️👍

[@aakashpoint6848]

Valuable and predictable formula in excel.
Thanks for your help 👍😊

[@Innozant]

♥️👍

[@shahabuddin1553]

Amazing Sir Great

[@amritathakur2036]

I m big fan of u after watching these helpful videos ☺️ thanks sir 😊 keep it

[@Innozant]

Thanks dear.. Recommend you to learn every playlist in sequence

[@superNareshg]

Dilse thank you sir ji.
🙏🙏🙏🙏

[@vinayakpotadar4093]

Super guruji

[@desperate_nobita]

Sir, ye Horigentel me krne ke liye Alt ke sath kya use kiya tha plz reply

[@AjaySingh-uo2jq]

Sir you are really talented Android I am looking to become like you

[@Innozant]

Thanks Ajay Ji

[@mdsani743]

Thank you sir

[@vivekkalshan3589]

Bahut achhi video h sir

[@Innozant]

Thankw Vivek ji👍❤️

[@kinghundred]

very great sir

[@VimalKumar-ih6ik]

Tusi Great Ho sir🙂

[@Innozant]

Thanks

[@rahulrakshe1988]

nice vedio. pl upload sperate excel in discription

[@Miyabhai_Gaming007]

Op sir aa gya thanks

[@raja3167]

Very good videos........

[@Innozant]

Thanks dear..

[@anishbiswas8546]

Thanks que sooo much sir . Thank queeee

[@YRS13]

Thanks

[@tajumir48]

Great ❤❤❤

[@dewtechawake7886]

Supper 💡🤠

[@aslkha3788]

Sir agar id ek hi hai aur 2 ya 3 rows me data hai too Kayse vlookup lagaye.. Aur agar row aur colmun me sathme kayse lagaye

[@nikhilanand3640]

Sir colum or row dono me chahiye to jaise mai 1 table banata hu or chahta hu ki table me I'd vale column k kisi bhi row me I'd type Karu or baki me apne aap details aa jaye

[@pareshpatel-me6wj]

Sir excellent
I want to highlight each page last row in excel sheet

[@shailendergupta2544]

How do I discuss personally if I do have any problems

[@mrromanticbgmlover4523]

TH-cam pe bahut sare teachers denkhe aapke jaise nahi

[@Innozant]

Really means a lot to me. keep learning

[@manishkumarpingolia393]

Brilliant👍 sir

[@Innozant]

Thanks Manish ji

[@hi-classfoods1617]

Zabardast

[@SunilKumar-cm9md]

Vlookup me columns ke formula sara data display kara sakte hai vase rows ke formula se bhi kar sakte hai

[@Innozant]

haan kyu nhi ..kya krna chahte h aap .data share kijiye

[@khurramtea]

Great

[@ankitmehra3074]

you are pro sir ji

[@Innozant]

❤️❤️😊😊

[@mrromanticbgmlover4523]

Gjb sir love you

[@raveeshkumarsingh5338]

Sir I salute you

[@Innozant]

Thanks Raveesh Ji

[@tipsentertainment2439]

My god you are amazing

[@Innozant]

Thanks dear ❤️

[@Naresh_Suwasiya]

Love u sir...👍

[@Innozant]

Thanks ..🙏👍Love you All❤️🙏

[@atulshukal4072]

जो दिखते हे बहोत बढीया वर्क दे पाते हो साहेब

[@Innozant]

धन्यवाद सर जी

[@gauravbhatia7987]

Good

[@RajveerSingh-bn9ny]

I want to learn about advanced excel so where do I start?

[@Innozant]

Kindly watch mis learning process from playlist announcement.

[@gouravverma001]

i love you sir

[@omprakashthakur4515]

Thanks sir, ☄️☄️

[@meditationmusic6482]

I likey Sir.

[@Innozant]

Thanks Sanoj

[@souravsingh1992]

Thankyou sir

[@Innozant]

Thanks Sourav ji

[@KailashChand-vg2fq]

Sir kya number ko word main convert karna hai bina VBA otherwise formula se
Please explain this

[@Innozant]

Haan banahnga video ispe

[@abdealirangwala1121]

Better transpose after vlookup than complicate..

[@growmore8056]

sir please 🙏. SQL par bhi video banayie 🙏

[@abhishakya5263]

Sir.... most underrated 5-6 functions ka ek hi complete video bana dijiye please

[@Innozant]

Ok..tips and tricks series me krenge upload ye underrated function

[@saktidharpurkayastha1054]

Want to learn SQL. Plz let me know how

[@surajrajput2752]

Sir ek confusion hai jo hum row and column me reference daalte hai wo naa daal ke ( row(), column () ) aise bhi ho sakta hai kya

[@Innozant]

Already maine Explain kiya hai row() ya column() me koi reference nhi denge to wo same cell ka ref lega,but humen ya to kisi ek cell ke ref ke base pe ya range ke base pe column no. Leke aana hai na.

[@surajrajput2752]

@@Innozant samaj gya sir thanks sir G

[@kaziasgarali5kazi714]

Pls share visualization link

[@mahaboobhossain5076]

tnx

[@gangaprasadpal2957]

Sir vlookup with row large data par bataiye right me drag karne par error show ho rha hai

[@martinfernandes5029]

so we can columns function instead vlookup match function are both the same

[@Innozant]

Yes..but match is good to get relative position from list

[@pushkalupadhyay]

Sir aap vlook up lagane ke baad ek colum me jo value a jati hai uske baad aap use increase karte huye baki colum ko select krte hai than value unme bhi fill ho jati hai wo kese hoti hai because mene krke dekha esa hua nhi

[@Innozant]

formula copy krte hai..ctrl r ya ctrl d

[@mahaboobhossain5076]

perfect

[@tusharpawar3557]

nice

[@Innozant]

GM.Thnks Tushar Ji👍❤️🙏

[@sairaaslam3292]

Sir aik ahsaan kr den .."apne jaise teachers tyar kr den"
Students nalaeq nahi hotay PARHANE WALE KO SAMJHANA ANA CHAHIYE "

[@Innozant]

Hahah... Thanks Saira...❤️❤️❤️🙏
Really means a lot to me...Chalo ek kaam karte hain..ydi aapne saath diya aur mere instructions follow koya to i promise you Wo Teacher Aap honge..Kya kehte hain..? think and let me knw❤️🙏 Waiting for your response
@innozantofficial telegram id

[@umermehmood3424]

I want to know, is it possible to auto serial number genrate after an interval 2 or more times

[@Innozant]

Yes...we can create the same ..

[@sabujdeury3199]

নাইছ

[@chandni_2910]

Ye rows ka concept hlookup me use hota h ?

[@Innozant]

Yes ..chahe vlookup use kro ya hlookup column colulns and row rows use kar sakte hain.

[@chandni_2910]

@@Innozant Ok Thanks

[@deepakchauhan4974]

sir ji apne is video me horizonally data extract with help of v look up and rows, but maine dekha ki ap look up value ke rows and coloumn dono freeze kar diye, ye kyu kiya sir, mai samjha nahi

[@Innozant]

Data range freeze kiya hoga dear..use koi prob nhi h.data set to freeze krna hi chaiye.kya samajh me nhi aaya.aapko?

[@deepakchauhan4974]

@@Innozant isme look up value hi freeze kar diya tha apne pura, lekin output aa gya

[@Innozant]

Ydi single cell me hi output lana hoga the n kiya hoga..but wahan aur criteria hota the freeze prob create karta

[@vikaskumar-wr3bz]

Sir why expertise only in excel? Can't we not learn VBA and and other programming languages that are better approach to stay in today's market. I have a little knowledge of excel machine as i am learning it since 2016 and i personally experienced that only having knowledge of some application softwares like MS excel, MS Access ext is not quite enough. Competitions are too high and definitely we have to become a developer instead of having knowledge of some selected application softwares.

[@Innozant]

I never say that only expertise in Excel is enough, Offcourse you need to enhance skills of VBA ,power bi ,SQL and python as well to establish in market.

[@vikaskumar-wr3bz]

You have unique talent. I am not just criticizing you. Sir i request you to please offer your videos on programming languages that are used to create all type of softwares.

[@manishkumarpingolia393]

Sir aap VB. NET BHI PDATE ho kya?

[@Innozant]

Haan Data analytics ka course hota hai innozant me