INDEX Function Explained (An Alternative to VLOOKUP) | How to use Excel Index - the right way

In this video explained INDEX formula as an alternative to VLOOKUP in Excel.
The INDEX function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function.
INDEX has 2 different uses:
1) look up a value that is at the intersection of a row and column
2) look up a specific table and then within that specific table look up a value that is at the intersection of a row and column.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Playlist Folder-Excel Lookup Functions-IndexExplained.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#indexfunction #Innozant #indexmatch #Indexmatchfunctionexcel

[@support1260]

Finally, found a great excel teacher. Thanks, sir for your explanation.

[@RA-rh5lb]

Sir ji , I have watched index related video many times however i couldnt understand, bas phir kya tha, jis ka koi nahi ussa KNNozant hai excel me 🙂,, not kidding nobody can beat your teaching style.. thank you Sir ji

[@Innozant]

Thanks dear..Keep Exploring 👍

[@Aman-vq6fz]

Really grateful to you for providing such a great content at no cost. Thank you so much.

[@theroyalmaratha96k]

Very underrated....This teacher give full efforts and have deep knowledge....Sir ko famous kar do

[@Innozant]

Thanks dear for your valuable appreciation and concern... Really means a lot to me

[@Lofi-wala024]

Yes, your way of teaching is awesome. You are a very good teacher as well as great person.

[@Innozant]

Thanks Thakur Ji... Really means a lot to me dear...Keep learning..step by step learning playlist are there ,Need any help you may contact us @innozantofficial telegram id

[@sarvodayaconventvidisha1757]

शानदार सर जी आपके बताने का तरीका बहुत ही प्रभावशाली व तुरंत ही सीख जाने वाला होता है इसके लिए साथ धन्यवाद

[@Innozant]

👍❤️

[@shoaibwarsi3338]

Sir amazing 😍 love from Pakistan 🇵🇰

[@aadimishra5333]

My favourite teacher of all time 🥰🥰🥰🥰

[@veerurajbhar1605]

Sir Apke video very helpful hai , Apke video se Aaj me Jetking Company me Selection hu hai Post ERP Executive.
Thankyou Sir.

[@user-ew4zo9me2v]

Wow I learned how Index works! Thank you. It was simple and easier to understand

[@devendergusain8974]

we guys will never ever get these kinds of videos in any other online or offline platform whether we pay thousands of rupees and here we all are getting it free of cost. thnx sir.

[@Innozant]

Thanks Gusain sahab itne valueable appreciation ke liye...🙏❤️aoke ye words bht mayne rakhta h mere liye dear🙏❤️

[@iamsainipawan]

Absolutely true 💯 agree

[@someonefrom2002]

@@Innozant sir aap bohot mayene rakhte hai hum logo ke liye❤️❤️❤️❤️

[@AnkitSingh-mh7ee]

Sir i will give 1000 out of 1000 for your explanation skills.

[@Innozant]

Thanks Ankit Ji . Really means a lot to me

[@satender7625]

This from my side ❤️

[@bimalkumar4984]

Thanks sir esme aage wala video chahiye.

[@awanishanurag1763]

Sir you are incredibly inspirational for all of us!

[@kaisarimam966]

you are very good teacher, best channel on excel

[@Innozant]

Keep Learning

[@dcreations4586]

Nice aap bhagwan se bhi mahan hai aapne details me know diaa🙏🙏🙏🙏🙏

[@sivareddy3745]

Hi Bro,
Your explanation is very good. I have seen no of videos but like you no one explain, But your explanation is there in Hindi.

[@Innozant]

Thanks keep learning

[@chitrabora5673]

I am grateful that I found your channel to enhance more on Excel 🙏

[@Innozant]

Thanks Chitra❤️Happy learning.God bless you

[@rajendrakumarjena7524]

You are great sir.i like your teaching style. You are explaing all formulas in simple way.

[@Innozant]

Thanks Rajendra Kumar Ji..for valuable comment.. Really mean a lot to me dear🙏❤️👍🙂

[@md.mostofakhan9950]

Very informative

[@aaqibpundeer9156]

itne kamal se koi nai samhata hai....very softly

[@Innozant]

Thanks Aaqib for such a lovely appreciation

[@pm143manish]

The way of explaning and in between your awesome smile make video completely awesome......
I have seen many RUclips channel's , but in all the Your's channel and one more GyanYagya these two are awesome in that.
Thanks for your valuable free knowledge and your effort.

[@Innozant]

Thanks Manish Ji . Really means a lot to me dear ♥️

[@Gold009]

Subhan Allah Dost Tumhaara Samjhaane Kaa Andaaz Badaa Hi Niraala Hai Hame To Pasand Aaya👌👍

[@Innozant]

Thanks dear..Keep learning ❤️

[@javedahmed8343]

Good explanation

[@VimalKumar-ih6ik]

Amazing Sir.

[@vknathan2010]

THANK U JI, YOUR TEACHING AND EXPLAINING IS GREAT AND SIMPLE & UNDERSTANDABLE TO LOW GRADE STUDENTS , KEEP IT UP. JAI GURU JI.

[@Innozant]

Thanks dear...Step by step Seekhiye ..Happy Learning ❤️

[@thegreatindia753]

Wow Maja aa Gaya sir great technic

[@Innozant]

Thanks dear

[@akak3585]

Nice video sir thank you very much

[@Tiwarikrishna556]

Love your teaching style

[@Innozant]

Thanks Krishna 👍❤️

[@navyamittal3257]

awesome explanation

[@Innozant]

Thanks Navya,Have a blooming career ahead ❤️

[@manishanegi9132]

thank you innozant for all the information and formulas it really helped me

[@Innozant]

Thanks Manisha..God bless You dear

[@subhashchandrabaghel8158]

Sir, due to yours Channel my 30% skill enhanced
all the best sir ji

[@Innozant]

No words 🙏♥️ for this ..Love u all..Thanks for like share and Support.🙏♥️

[@nitinshirke375]

your videos are very interesting and knowledgeable

[@Innozant]

Thanks dear

[@aadesh6122]

God of Excel for us🙏🏻🙏🏻🙏🏻

[@Innozant]

Thanks dear .Keep learning ❤️

[@mycellphone3070]

You have awesome capability to teach your learners. Its really GREAT....!!!

[@Innozant]

Thanks dear ❤️❤️

[@jagdishguntuka2330]

What a nice explanation I never sir like you

[@Innozant]

❤️👍

[@sonukumarskp6933]

Very good teacher.......

[@hemantgusain1260]

Sir, you explained index function very simple way.

[@Innozant]

Thanks Hemant Ji

[@kanitar786]

ur teaching skills is amazing

[@Innozant]

Thanks Waseem sahab❤❤

[@ajaypundit5060]

Awesome 👏

[@bdeepakkishore5872]

thank you sir justknow i download your entire drive for practice

[@babuhkonameti4294]

Thanks sir 🙏

[@satyatathya5176]

Excellent

[@Innozant]

Thanks Hitesh

[@rajuvardhanmogadali2218]

Sir, your explanation is good i am happy

[@Innozant]

Thanks dear ..God bless You dear

[@gauravbhatia7987]

Thnq sir index references ache se sikhna hai muje iska nhi pta tha

[@Innozant]

👍👍🙏❤️yes

[@ganeshwarthayalapally1966]

Thank you sir, it is very helpful

[@DRSVENTURES]

you choose row and clm row : horizontal & clm : vertical

[@mohitjaiswal4023]

Great sir 👌 this video help me to understand index concept. 👍

[@Innozant]

Thanks Mohit Ji.. Happy Learning ❤️

[@pawanwakale8801]

Index , Vloop se thoda different hai , atleast vloop itna parameters nhi fill karna pad raha , Thank you sir

[@Innozant]

Thanks Pawan ji

[@harivanshgautam3424]

To the point information about index function 🙏

[@Innozant]

Thanks Harivansh Ji

[@harindershah1180]

Thanks sir

[@shreekantmahajan3917]

very Nice

[@sharesbest5867]

Your explanation is very in-depth yet beautiful and interesting. Kept me intrigued through out. Thank you. I have subscribed and will follow your videos.

[@Innozant]

Thanks..Keep learning

[@ishtiaqkhan1832]

Great, wonderful explaination. Stay blessed

[@Innozant]

Thanks Ishtiaq khan sahab❤️🙏

[@naeemkhan-tm9hx]

Very nice

[@Innozant]

Thanks Naeem sahab

[@kinghundred]

very excellent sir

[@bhoopendraraghav9781]

Excellent teacher

[@Innozant]

Thanks Bhoopi..Wait for next video... uploading Now...,😊

[@avinvashisht5979]

I am grateful that I found your channel to enhance more on Excel skills sir , please let me know if u have VBA videos also.

[@Innozant]

Thanks, Excel & Power BI Videos course are available now and VBA is in making processs

[@avinvashisht5979]

@@Innozant sir do tell me when the videos will be created or all the playlist for VBA using 2019 version.

[@sverma7798]

Gajab

[@chetnakikan3721]

🙏SIR VERY WELL EXPLAINED

[@Innozant]

Thanks Chetna..Happy Learning

[@dilipshedge8503]

Thank you so much 💗💗

[@Innozant]

Thanks Dilip Ji

[@MAHIFBD]

SUPER

[@satishojha6240]

Simple and smooth learning sir keep it up waiting next video.Gn

[@Innozant]

Thanks Satish...Itna jaldi kaise good night dear..Abhi to ek video aur aana hai abhi..😊

[@satishojha6240]

@@Innozant ohh sorry sir

[@paarasri9277]

Hi Sir...nice 2 meet u..i saw yr vdos n very helped me thank u 100much. But need 1 help reagrding my work

[@Innozant]

Thanks..kindly share your queries

[@awanishanurag1763]

So ultimately which combination is more power among the two i.e. Vlookup+ choose or Index ( reference to multiple table)?

[@atulshukal4072]

Very good Sir

[@Innozant]

Thanks Atul Ji🙏❤️

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l 🌷🌷सीखते रहो, सिखाते रहो 🌷🌷🙏👍

[@sandeepaswal8944]

Namstai Sir ji, Sir aapnai Index function details mai bahut acha samjya. Index hota kya hai. Sir aapnai aajtak jitnai bhi tutorials shikhyai hai. Mainai har Topic kai notes ready karta hu. Aur unko bhi revise karta rahta hu. Aapkai har points notes mai likhkar muje bahut kaam aatai hai. You are excellent teacher. Thank you so much sir ji.

[@Innozant]

Thanks ..learn very play list in sequence step by step
Like..First complete Basic Excel series ...then sorting,Filter adv.filter and so on...

[@technicalvipinupreti1573]

Sir I want Doing Course advance excel

[@ravimanchandani2421]

Please make videos on Xlookup.

[@Innozant]

Hi Ravi..Please find seprate playlist of office 365 .All New Functions videos are there .❤️

[@bdeepakkishore5872]

thank you for share entire drive of yours will you please shareyour entire frive for me by giving edit acess for download and practice

[@Innozant]

It is open for public to acces

[@bdeepakkishore5872]

Ok sir i check that files and download that files for practice sir

[@aakankshasrivastava9497]

Very well explained,Keep it up sir👍 Waiting for d next video 😊

[@Innozant]

Uploading Soon....CountIf Function bundle example

[@dpak_sharma]

Sir you are a good teacher hum hmesa aapse seekhtey hein pr aapne power query playlist adhoori chhod di poori nhi sikhayi.pls usko complete kijiye

[@amitapattanaik1071]

Your teaching style is very learning & entertaining
When will you start vba sir

[@Innozant]

Thanks Salil,After finishing these current running series

[@satyamsharma8274]

v lookup me choose option se left value bhi pic kr skte hai

[@arunkushwaha748]

sir ek sheet se dusere sheet mai data kaise match karege by index
eg common field is any code

[@mamtamishra7882]

How can we sort the date in google sheet, please help

[@End2over]

Amazing

[@Innozant]

Thanks.Happy Learning

[@Viishhal.]

I need help on index formula, how can i send my file.

[@bishtlokesh1297]

Very well sir ji🙏💐

[@Innozant]

Thanks Lokesh Ji

[@bishtlokesh1297]

Please can i get your what's app number please

[@Innozant]

@@bishtlokesh1297 7065069985

[@RA-rh5lb]

Sirji why didnt you take take heading when you drag for the array.. I have a confusion here when to use hearder and when not in array or range

[@waqasmaqbool3356]

i have subscribe

[@Innozant]

Thanks

[@faheemshahxad1306]

i have form 4 result sheet in excel week wise now i want a major result sheet of all 4

[@DEviL-sp4uy]

Guruji offset function par ek video bna dijiye

[@Harish.Prasad.Semwal]

4:00 4:23 5:31 6:14 8:19 9:46

[@faheemshahxad1306]

hello sir
I have a problem with excel if you solve this problem

[@meriawaazhindi5217]

❤️❤️❤️❤️

[@sandeepkulkarni3557]

Sir, in Header text as Result is it possible ?

[@Innozant]

Didn't get your query ?

[@sumitkumar-re5pq]

जब हम manual ही row and colom count कर लेके तो index क्या need hai या formula log data per nahi chalta

[@rajuvardhanmogadali2218]

Dear Sir,
Can you make a video of Filter Option because of when I am going to preparing salary sheet my emo id not coming into serial orders why?

[@Innozant]

Why..whci version of Excel you are using now

[@kunalkohli6097]

I am coming here for learning index not for comparing of vlookup and index.😅

[@Innozant]

Kohli sahab kindly note that you need to watch videos in sequence from playlist.

[@ManojKumarBaghel1432]

Guru ji basic Excel ki list main index , match or indirect , choose and etc function nhi h.
Ye advance wali play list m hain

[@Innozant]

Yes Manoj ji harek ka seprate playlist banaya gaya hai . description me jake videos in sequence playlist dekhiye eke baar

[@gauravsemwal2246]

sir is function ko explain kar dijiye =M9-IF(ISTEXT(M11),INDEX($M$12:$U$12,MATCH(M$2,$M$10:$U$10,0)),M10) Last main jo cell selected Hai M10 uska purpose Kya Hai.

[@devokedevtech2750]

Sir vlookup right to left work karta h agar ham agar ham table arrey ki jagha choose function ka use kre, tab to kaam krega na sir

[@Innozant]

Dear Dheeraj phirse suniye video maine kya word use kiya hai .ki vlookup ke bus ka akele nahi hai ki wo khudke left se data leke aaye..bina choose ke help se it won't possible..jab choose function aayega then we talk abt vlookup to left and hlookup to top

[@Pankaj_ziddi_boy]

sir i m from noida may I learn ofline excel advance excel tell me
you are from where sir

[@Innozant]

Hi Pankaj ,You may call/whatsapp us for more information about live/offline classes..Innozant is located at New Ashok Nagar Delhi ♥️

[@paramjeet975singh3]

Thanx sir excel k bad power bi karaoge vaise?

[@Innozant]

Lookup series video uploading In sequence..
Vlookup,match,Index,Choose,Indirect then no. Aayega offset ka..
Kindly note that i am not uploading a demo video of every topic.. Uploading Complete Class lecture step by step..Have patinece..Aisa koi topic nhi hoga jo aapko is channel par nahi milega.vut it will take time

[@Innozant]

Power bi bhi karana hai. But pehle excel over hone ke baad

[@paramjeet975singh3]

@@Innozant ok sir thank you

[@hemchandpawar459]

Sir aek vedio advance excel ki bnado please 🙏

[@Innozant]

Already pura adv series ka playlist hai dear

[@akankshasingh3466]

Hi sir,I have given interview for MIS today and applied Index formula instead of vlookup. Kya mujhe consider kiya jayga?

[@Innozant]

Offcourse Akanksha ,Applying index is far better and it's best alternative of Vlookup if your output is exactly what they are expecting❤️👍

[@akankshasingh3466]

@@Innozant thanku sir 🙏 I hope this time I will succeed

[@Innozant]

Best of luck.dear..Hope for the best

[@MaryamShakir-hp4yy]

Sir hme sum,Suma,sumir,sumifs ki vedio chaye jese AP n count,counta,countif,countifs ki B'nai h wese hi

[@nilanjanadhikary7343]

For you I got good hike, I need to donate some amount to you, how to donate?

[@Innozant]

Congratulations Nilanjan..Have a wonderful career ahead.
Your every sucess and achievement is my Fees.😊👍❤️