find data from matrix and show me in another sheet base on my selection and relative data

Dear All
I will attached a file and exactly show you what I want . just please show me your answer in my file if you could. thanks in advanced for your attention

Hi,

See the file.

Dear misrasomendra
thanks alot
but it has a problem when you input the code in "O4" first cell in result "Q4" shown as empty ! what is for could you plz fix it

It's not showing in my end, you may be pressing ENTER to execute the formula, but instead you have to press Ctrl+Shift+Enter to execute the formula.

Thanks a lot
it is right
you are great

You are Welcome, if you like you can click the reputation star for my solution.

Dear misrasomendra
sorry for my occupation
when I copy your formulla in my Origin file exacly in your way (ctr+shif+enter)
the result that give me is unic in every cells what is my wrong ?

Have you adjusted the ranges in the formula as per your original file?

Dear misrasomendra
in file that I attach : C3:M3 / C3:M23 /
In my original file : E3:AY3 / E3:AY162 /

What the result you are getting?

Error in downloading file, kindly upload it again.

I attach the file again

See the file.

Dear misrasomendr
its worked
but could you plz tell me what is my wrong

Yes, You had selected the entire range D2:L2 and entered the formula and press Cntrl+Shift+Enter so the whole range becomes one array with same result. Same you had done for heading also.

You should put the formula in D2 alone execute by Ctrl+Shift+Enter and copy it across.

Hope now your problem is solved and you can mark the thread as SOLVED and give me some reps