**Question description:**

*This user has given permission to use the problem statement for this blog.*

help with
INDEX(IndexArea,MATCH($M$5,MatchRows,0),MATCH($M$6,MatchColumns,0))

Solved by Z. Y. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
17/12/2017 - 04:35

welcome sir

Excelchat Expert
17/12/2017 - 04:35

thank you for selecting got it pro

Excelchat Expert
17/12/2017 - 04:36

plese tell me how can i help you?

User
17/12/2017 - 04:36

can you explain this formula?

Excelchat Expert
17/12/2017 - 04:37

yes sir sure

Excelchat Expert
17/12/2017 - 04:37

INDEX function returns a value in a table based on the intersection of a row and column position within that table

Excelchat Expert
17/12/2017 - 04:38

and

Excelchat Expert
17/12/2017 - 04:38

The first row in the table is row 1 and the first column in the table is column 1.

Excelchat Expert
17/12/2017 - 04:38

The syntax for the INDEX function
INDEX( table, row_number, column_number )

Excelchat Expert
17/12/2017 - 04:39

parameters are as follow

Excelchat Expert
17/12/2017 - 04:39

table is A range of cells that contains the table of data.

Excelchat Expert
17/12/2017 - 04:40

the row number is The row position in the table where the value you want to lookup is located. This is the relative row position in the table and not the actual row number in the worksheet.

Excelchat Expert
17/12/2017 - 04:40

column number is

Excelchat Expert
17/12/2017 - 04:40

The column position in the table where the value you want to lookup is located. This is the relative column position in the table and not the actual column number in the worksheet

Excelchat Expert
17/12/2017 - 04:40

let we see and example is shared worksheet

Excelchat Expert
17/12/2017 - 04:41

i make one table ok?

User
17/12/2017 - 04:41

ok

Excelchat Expert
17/12/2017 - 04:41

now i apply an index function

Excelchat Expert
17/12/2017 - 04:42

in index function as per its syntex

Excelchat Expert
17/12/2017 - 04:42

1) i select the table B2:D4

Excelchat Expert
17/12/2017 - 04:43

then i mentioned the row number as 3 and column number 3

Excelchat Expert
17/12/2017 - 04:43

so it give us the value from the table by row 3 and column 3

Excelchat Expert
17/12/2017 - 04:44

and you can change the values of rows and columns and you will get different outpus

Excelchat Expert
17/12/2017 - 04:44

is it make sence?

User
17/12/2017 - 04:44

yes

Excelchat Expert
17/12/2017 - 04:45

in your function the table is IndexArea

Excelchat Expert
17/12/2017 - 04:45

and the row is MATCH($M$5,MatchRows,0)

Excelchat Expert
17/12/2017 - 04:45

and the column is MATCH($M$6,MatchColumns,0))

Excelchat Expert
17/12/2017 - 04:46

do you konw about the match function?

User
17/12/2017 - 04:46

yes

User
17/12/2017 - 04:46

I understand the function

Excelchat Expert
17/12/2017 - 04:46

can you need more help?

User
17/12/2017 - 04:46

no thanks

Excelchat Expert
17/12/2017 - 04:46

can i close this session?

User
17/12/2017 - 04:46

yes sure

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*