Functions similar to vlookup

In regards to functions, please find my comments/notes in attachment. Also please note there is worksheet tabs for you to look also.
It would take some time for you to enter some answers on this worksheet.
Much appreciated for your time and help.

Have a look at attachment again, see my comment in green highlighted as the first step I would like the blue section to be done.
Should I use RANK? If yes, could you help what is the text/value next to RANK.
Thanks for your help.

I used a macro:

copied the cells from the range specified, pasted to where you want them sorted, then did a sort.

added this all into a button.

see attached for how i did it.

it's not fancy, but hitting the button will resort every time and get the results you want, i think.

Also here is an example of using rank that i came across...maybe this will help you to have a more dynamic field that you can copy down for as many weeks as you like. see attached :-)

Thanks cwn7499 for your wonderful help. It works well however, I would like to have the first column sorted in order first then followed by second column instead of vice versa. See attached. Thanks again.

Thanks heaps cwn7499...Problem nearly solved there but one more problem that need to be solved, in regards when there is more than one bowler are not playing, their score will be zero. The name appeared to be duplicated. See attached. Appreciated your help.

Thanks DonkeyOte, this is fine. Problem solved. How can I posted "solved".