Help with look up function please

D

dg

Hi

I have a worksheet that has golf scores for a charity golf day that I am
running. One part calulcates the team handicaps, and when the team's score
is put in, it ranks the teams from 1 to 40. I would like an additional
worksheet to then put the team rankings from 1 to 40 and to have the team
numbers along side to make it easier to spot the winner.

My data is in the following colums - a- team number, E team score -handicap,
F - ranking of team. I would like my new worksheet to have the ranking in
column A and the team number in column B.

Any help appreciated.


--
IMPORTANT: This email is intended for the use of the individual addressee(s)
named above and may contain information that is confidential privileged or
unsuitable for overly sensitive persons with low self-esteem, no sense of
humour or irrational religious beliefs. If you are not an intended
recipient, any dissemination, distribution or copying of this email is not
authorized (either explicitly or implicitly) and constitutes an irritating
social faux pas. No animals were harmed in the transmission of this email,
although the dog next door is living on borrowed time. Those of you with an
overwhelming fear of the unknown will be gratified to learn that there is no
hidden message revealed by reading this backwards (ereht si ro), however, by
pouring a complete circle of salt around yourself and your computer you can
ensure that no harm befalls you and your pets.
If you have received this email in error, please add some nutmeg and egg
whites, whisk, and place in a warm oven for 40 minutes.
 
A

akk

HI

Copy column a - team number, and paste to the right(say
G) of F - ranking. Then copy the entire column F to
another sheet in column A. In column B give a look up
formula =VLOOKUP(A2,Sheet1!$F:$G,2,FALSE)

Regards
Abhilasha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top