**Question description:**

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

I need help on index and match where the return is not correct

Solved by B. B. in 20 mins

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

Excelchat Expert
28/03/2018 - 05:16

Helloo..

User
28/03/2018 - 05:16

Hi

Excelchat Expert
28/03/2018 - 05:17

can you share more details regarding the index & match issue?

User
28/03/2018 - 05:17

can i put my example in the spreadsheet?

Excelchat Expert
28/03/2018 - 05:17

if you have a sample excel.. it would be helpful to solve..

User
28/03/2018 - 05:18

ok

User
28/03/2018 - 05:19

i am trying to match the name in I2 and H3 with a table on the left

User
28/03/2018 - 05:19

it should return 11397

User
28/03/2018 - 05:19

but I get Pay

User
28/03/2018 - 05:19

is there anything wrong with my formula?

Excelchat Expert
28/03/2018 - 05:20

i've fixed the formula..

Excelchat Expert
28/03/2018 - 05:21

the array for the index should refer to the location where the data is being extracted..

User
28/03/2018 - 05:22

i copied the formulat to I4 cell

User
28/03/2018 - 05:22

however it is not working

Excelchat Expert
28/03/2018 - 05:27

we need to interchange the match patterns...

User
28/03/2018 - 05:27

what do you mean by that?

Excelchat Expert
28/03/2018 - 05:27

as 2018M01 - M12.. keeps increasing on the row..

Excelchat Expert
28/03/2018 - 05:28

hence the result of that should be used for the row input in INDEX formula..

Excelchat Expert
28/03/2018 - 05:28

i have extended the formula for rest.. and the result seems to be fine

User
28/03/2018 - 05:28

sorry, i don't quite get it. Can you show me which part of the formula you make the change?

Excelchat Expert
28/03/2018 - 05:30

you have two match formula.. one is for months.. and other is for names..

Excelchat Expert
28/03/2018 - 05:31

in your index formula.. you had array, then first output from name and the next output from month

Excelchat Expert
28/03/2018 - 05:32

since the output from month increases the row #.. i interchanged your formula .. to get the required result..

User
28/03/2018 - 05:32

hmmm

Excelchat Expert
28/03/2018 - 05:32

marking this session as done..

Excelchat Expert
28/03/2018 - 05:35

i have updated the formula for column J also..

User
28/03/2018 - 05:35

thank you

Excelchat Expert
28/03/2018 - 05:36

please close the session from your end .. and share the feedback..

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