Index function works in the first row but not the others

[mehmetics]

Index-small function runs ın the first row of the table, but when I copy paste it downward it crahes. Why?
I appriciate for your help.

[AliGW]

You have not entered the formulae correctly. Each one needs entering 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.

Once this is done for all the formulae, you can drag copy them down.

[MrShorty]

I could be misunderstanding what you are trying to do, but it looked to me like these should be array functions rather than regular functions. I went through row3, pressed F2 (to enter edit mode), and reconfirmed the functions with ctrl-shift-enter. Also, I noticed that the formulas in column A were using a couple of relative references where the other columns were using absolute references, so I changed those to absolute references. With those two changes, I could copy row 3 down to row 9 and the result looked just like your "result should be" table below. Is it as simple as changing these to array functions?

[mehmetics]

Thank you AliGW and MrShorty. I tried what you said thousands of time (I mean making the formula an ARRAY FORMULA by pressing CTRL+SHIFT+ENTER) up to his moment but I could not get the result. But now it is OK. I did not understand why it is so. Thank you very much.

[AliGW]

Glad to have helped.