INDEX MATCH Excel

[ferfer20]

I have a problem using the INDEX + MATCH function. In the attached file I have a table with 9 different index names [Columns K2:S2] which in turn are the same ones that appear in Column A, now I need to organize the information for each of them, that is to say that the data that is recorded in Column A [cells A2:A1964] is replicated and matched with the corresponding column names [K2:S2] for each respective index.

The operation I want to perform is if the value of cell K$2 matches the value of column $A$3:$A$1964 and the value of cell $I3 matches the value of column $C$3:$C$1946, bring me the corresponding value of column $E$3:$E$1964.

If the value of cell L$2 matches the value of column $A$3:$A$1964 and the value of cell $I3 matches the value of column $C$3:$C$1946, bring me the corresponding value of column $E$3:$E$1964.

If the value of cell S$2 matches the value of column $A$3:$A$1964 and the value of cell $I3 matches the value of column $C$3:$C$1946, bring me the corresponding value of column $E$3:$E$1964.

For the first column [K] the function works, as well as for the first row [K3:S3], while for the range [L4:S220], it repeats the same number, where can I be making the mistake?

Is there a different solution that does not involve a matrix form?

Thank you for your valuable comments

[Pete_UK]

This is a duplicate of a thread you started just 4 minutes ago. Read the Forum Rules at the top of the screen and you will see that duplicate threads are not allowed.

I'm sure a moderator will come along soon to block this thread, so carry on in your other thread.

Pete

[FlameRetired]

Done Pete.

[TMS]

Looks like we're continuing in this thread ...

Try:

Please Login or Register  to view this content.

committed with Ctrl-Shift-Enter rather than just Enter. Copy across and down.

[ferfer20]

Thanks for the information, I am new to the group and was unaware of the rules!

[ferfer20]

Dear TMS, thank you very much for your valuable information, indeed this procedure has given me the expected result, very grateful for your time and dedication!

[TMS]

You're welcome. Thanks for the rep.