Index and Match Function together help.

Hello, I am struggling with a function. I think I need to use Index+Match (as it need to match column and row, then return the result).

First I need to Select, User from list. Let's say James for eg.
It should then check HP route in Objective table and return answer in Objetive column in first table.
For example: for James, it should retun me 7. (Image attached).

=INDEX(F4:I9;MATCH(B1&A4;E3:I9;0))

Thanks for help!

indexmatch.PNG

You need the 2-dimensional construction of INDEX(MATCH, MATCH)

Because you are pulling one output -- the value inside the second table -- from TWO inputs, (1) the person's name, and (2) the corresponding row value in that first table.

put this in C6:

Please Login or Register  to view this content.

and pull down through C11.

That should do it.

hi there. first of all, it doesn't seem like your formula matches your screenshot. but based on the screenshot, maybe:
=INDEX(G6:J11,MATCH(A6,F6:F11,0),MATCH(B3,G5:J5,0))
change my commas to semi-colons

next time though, do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.