How to use Index Function in Excel (Array & Reference)

How to use Index Function in Excel : Learn both about Array and Reference forms of index formula. Get Excel to return a value in an array based on the row and column numbers you specify.
What is covered in this Excel tutorial:
==============
1. What is Index function and how does it work?
2. Difference from Vlookup function
3. The difference between Array and Reference form of Index function
#ramgopalexcel
This video is created by Ramgopal from Presentation Process in Excel 2016 for Office 365. Visit Presentation-Process.com for more.

[@nikhilsoni1177]

He is the only guy on whole youtube who explain index fuction so well.

[@AmnaIkram-mt4ey]

Superb explanation

[@happymm2008]

Thank you. You explained so well and patiently. I am looking for index function reference area examples throughout internet and your example is so clear to understand.

[@tubosunoyedapo7869]

Your teaching of excel is really lovely and impacting. Please I want you to produce a video that will teach how to prepare school time table that will be high flexible.
With the following features:
1. A teacher possibly taking more than 1 subject.
2. A class possibly having 2 subjects at the same periods.
3. Each subject having its own no of periods per week.
4. Possibility of science subjects in science laboratory, with consideration that two/three classes may be sharing the same laboratory.
And other possible features.
I will appreciate it if you can work on it. Thanks.

[@VinodKumar-ee1st]

Wonderful sir, stay always blessed 🙏👌🤗

[@javedahmed8343]

Very nice

[@hazemali382]

very Great tutorial

[@colourpalette6604]

Great Explanation sir.

[@ijazahamed87]

Excellent presentation

[@XMegaJuni]

Loved the video. Keep up the good work!

[@mujeebrahman2476]

Very useful information

[@ashavm8153]

Nice Explaination

[@abdulazizqureshi2256]

THANKS A LOT SIR

[@manmohanyadavg260]

Excellent

[@sunilmodi6249]

Pls teach about index and match two seperate spred sheet lookup

[@ManmohanSingh-kt5dw]

Thank you

[@yaswanthkumar9997]

Not interested if we are working in huge data is it possible to identify row and column try to explain the reference fn in advanced level by inserting vlookup in index

[@juandelacruz2142]

(1st group column ) Given: 12 18 35 10 42 5
(2nd group column ) Rank: 3 4 5 2 6 1
(3rd group column ) Final Arrangement: 5 10 12 18 35 42
Note: Given, Rank and Final Arrangement it should be the same in row but different in column