Populate each item to proper place

Hello everyone
I have names and each name has some wishes (sections desired are four : Range("M12:M15"))
The distribution would be according to the highest marks and limited to the maximum number allowed for each section which is in range("N12:N15")

Note that the wishes in columns("F:I") are important .. I mean may be someone has high mark but his wish "Trade" for example so the wish should be put in mind .

I attached the expected output to illustrate my issue

I tried to solve the problem step by step by formulas as illustrated in sheet1 ...
Please see the attachment, it may help to solve the problem.
Forget the attachment in post 1 .. I figured it in a wrong way
Focus now on the attachment in this post

I've looked at your post and explanation in post 1. I've also looked at your file in post 2. I do not understand what you are attempting to do. Please clarify in simple language. Explain it to me like we were standing in line in a coffee shop.

Row\Col	B	C	D	E	F	G	H	I	J	K
2		Who	Moh	Mwared	Tas	Trade				D2:G3: Input
3		Max	7	6	5	2
4		Assigned	7	6	5	2				D4: =COUNTIF($H$7:$H$26, D2)
5
6	Score	Name	1st Pref	2nd Pref	3rd Pref	4th Pref	Assign	Pref
7	15.4225	Alan	Moh	Tas	Mwared	Trade	Moh	1		B7:G26: Input
8	15.3375	Barb	Trade	Tas	Mwared	Moh	Trade	1		H7: {=INDEX(D7:G7, MATCH(TRUE, COUNTIF(H$6:relN, D7:G7) < LOOKUP(D7:G7, $D$2:$G$3), 0))}
9	13.4075	Cain	Tas	Moh	Mwared	Trade	Tas	1		I7: =MATCH(H7, D7:G7, 0)
10	13.3425	Dana	Trade	Tas	Moh	Mwared	Trade	1
11	13.2600	Eric	Trade	Mwared	Moh	Tas	Mwared	2
12	13.1550	Fran	Tas	Moh	Trade	Mwared	Tas	1
13	13.1450	Gary	Mwared	Trade	Tas	Moh	Mwared	1
14	13.1275	Hana	Mwared	Tas	Moh	Trade	Mwared	1
15	13.1250	Ivan	Tas	Mwared	Trade	Moh	Tas	1
16	12.9375	Jane	Moh	Mwared	Trade	Tas	Moh	1
17	12.8450	Kent	Trade	Moh	Mwared	Tas	Moh	2
18	15.2650	Leah	Moh	Mwared	Trade	Tas	Moh	1
19	14.8700	Mark	Tas	Moh	Mwared	Trade	Tas	1
20	14.2750	Nina	Mwared	Tas	Moh	Trade	Mwared	1
21	14.2450	Otto	Mwared	Tas	Trade	Moh	Mwared	1
22	14.1775	Peri	Moh	Mwared	Trade	Tas	Moh	1
23	13.9675	Quin	Tas	Trade	Moh	Mwared	Tas	1
24	13.6500	Rene	Tas	Trade	Mwared	Moh	Mwared	3
25	13.4550	Seth	Trade	Mwared	Tas	Moh	Moh	4
26	12.8275	Tina	Moh	Mwared	Trade	Tas	Moh	1

The names in row 2 must be in alphabetical order.

Thanks everybody
I have attached my solution in post 2
I created another sheet .. copy all the data and sort according to Marks Column
Then used some formulas as illustrated in sheet1 till I could achieve my results in Column R

After that I used a simple formula to look for the name and return the final result

So simply I need to summarize all these steps to be executed in code once without the aid of creating helper sheet or even create it temporarily and at the end to be deleted ...
Hope it is clear now

@shg
Is it necessary : The names in row 2 must be in alphabetical order ???
Thanks for help
I will give it a try in the original file

Thank you very very much mr. Karedog for this great effort

I tested the udf and found the output is not correct for mine ...
The logic is that Marks are the first criteria so the person who got the highest mark is the first person to apply his wish (he has the prioprity)

Look at row 19 after applying the udf : you will find that this person has 15.27 so he has the priority of first wish
The udf fucntion gave me "Tas" while he is worth "Moh"
Generally please look at the results in sheet1 column R in post 2 attachment to see the final and correct results

Mr. Karedog
I get confused....I revised my attachment and found that in sheet1 I put wrong formulas .. I correct the formulas to get the desired results
Now the desired results are in sheets("Final") in column O
But the results are different from your UDF results

Please look at this attachment to see the idea again. May be I'm wrong

I didn't test the last modification yet ...
As for your comment :
If you look at the attachment in post 8 you will find the correct results as you state
So jth7 can get the second wish ...
As for your questions : the wishes are input data for each person ..they represent their wishes (may has high mark but he wishes any section)
Hope it is clear
I will test your post 9 and come back again

Mr. Karedog
It seems that I'm very confused of results
Actually your logic is correct ...
Look at Sheet1 at Column AB I put my notes manually after taking your results and copy and paste as values and re-sort the range according to Marks Column
Look at Column("AB")

Thanks for your great effort

I will give it a try in the original file

The workbook is posted at https://app.box.com/s/rfeplgz9tsgkji06rxt61tqd4gb5la3b

@Shg
Thank you very much for this great solution ...
It's very well except for one important thing : you neglected in your file column B titled (Score)
It's very important and must be put in mind

As an idea ... what about sorting column Marks then apply shg solution .. Will it help to solve this complicated issue?

Mr. Karedog
Thank you very very much for solving this complicated issue
Now it is very very good and excellent solution

THANK YOU FROM NOW TILL I SURVIVE

you neglected in your file column B titled (Score)

It was not neglected; the formula assumes that your data is sorted by score, as it was in the example.

Let that not diminish Allah's beneficence upon karedog.

@shg
Is it possible to sort the data by formulas?
Thanks for great help
I liked your solution alot but it is not my complete need.
Can it be possible to create another sheet and by formulas sort the data then we can get our desired results without VBA code in that case?

@Karedog
How can I follow the steps of UDF function by pressing F8 to watch how it works?

Mr. Karedog
I'm so sorry for bothering you again
I have attached the original strucuture of the file as I couln't get the udf function well
Now I have seven wishes not only four
There are some comments in row 24 about Wishes columns and Marks column ..
The range of the second parameter is range("C11:D17")

Thanks advanced for help

Thanks a lot Mr. karedog
I tried your modification but I got Value error in the output range ...
Note that the wishes are not just four, it is seven wishes in the file Columns("H:N")

Thanks a lot for this great and very helpful UDF function
It's a wonderful gift
And it needs about a month to study the great lines of code to learn from you

Just a little question:
Is there a reference in the udf function to the number of Wish columns? and the Marks Column?
If possible I need to refer to the Marks Column in the formula
eg
=wish(E25:Y378,A11:D17,H:N,Y:Y)
If this modification will take long time, don't care about me ..

I will try to study it in 27 days (I will work hard to achieve that)

Believe me saying thank you is not enough at all
I need more words to thank you for this great and magic solutions

But what a pity .. I'm just obliged to say only : thank you very much and god bless you

Mr. Karedog
I'm sure you will hate me because of many requests>>
Can you add to the code .. if the person has mark less that specific mark say 10 , if the person has a mark < 10 then in the result should appear the word "Without" ...?

Perfect perfect perfect
you are perfect and awesome ..
I feel that I am in a dream .. really I feel that
I can't imagine that I achieved all my goals today

Till we meet again in another issue I have to say good night and goodbye