Index/Match Multiple Criteria

Hello all

I was wondering if somebody could help me out.

Well, i ve encountered a problem that I dont know how to solve.

I have multiple criteria rows, using the match and index function. The data that I am getting from the formula is all scrambled. Some data are correct, some are not.
Usually the first row is correct and then the rest of them are not.

I ve tried using "&" and "*", but still no success.

The first sheet is where the problem is. The second sheet is where my data is.
In yellow background are my lookup values (it has a comment in them, telling what column it refers to in the second sheet)

What I need is. To match those 4 rows and then a column (which is not that important, i can just put the column number).
I think the problem is in the "ordem exercicio" row.
This column is an order of things to happen. So I have and advanced student, normal, that will do the treino A, and then i have 12 exercises in order for him to do. And i need to select all of these criterias in the first sheet, so i can see what are all the exercises in order for him to do and then values referring to those exercises.

I hope I could explain well what my issue is and that somebody can help me.
Thanks in advance!

try

in F4

=INDEX(Table1,MATCH($B$3&$B$4&$B$5&E4,Table1[Nivel de Treino]&Table1[Dia de Treino]&Table1[Tipo de Individuo]&Table1[Ordem Exercicio],0),MATCH(F$3,Table1[#Headers],0))

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Repeat for other columns

Thanks a lot!!
It worked

I had actually tried before the lookup values in a row like how you told me to do, but somehow i have not made it work and now it did work.
Thank you

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Sure, thanks!
Done