Excel - INDEX Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.