Hi
Let's say you have your list in Sheet 2, and your schedule in Sheet 1
So, in sheet 1 you will enter the next formula in the cell next to the
number you wnat to reference. For the sake of this example, say the number
is in Cell C1, and you want the name in C2.
=IF(ISNA(VLOOKUP(C1,Sheet2!A:B,2),"Not Known",(VLOOKUP(C1,Sheet2!A:B,2))
If you do not have the number available, it will show Not Known, else it
will show the name
" wrote:
Thanks, I have the names numbered in a A and the names in
column B. But I don't know how to do the VLOOKUP formula.
-----Original Message-----
If your list of names is not numbered at present, then
insert a column to the
left, where you can insert the relevant numbers, e.g. A2
= 1, B2 = Say Pete
Summers.
Where you want to show these names, based on numbers,
you can then use a
VLOOKUP formula
"Fredrik Wahlgren" wrote:
wrote in message
...
I have a bowling league schedule that looks like
this:
Lanes 1 2 3 4 5 6 7
8 9
Teams1-2 3-4 5-6 7-8 9-10 11-12 13-14 15-16
17-18
The top numbers represent lanes or alley numbers,
and the
second row of figures represent the team members.The
team
members numbers represent a name from a list. For
this
question the names on the list are a,b,c,d,etc
through r
(18 total) I would like to have formula that I could
change the team members numbers to team members
names,
i.e,; 1=a, 2=b, 3=c, etc all the way through the
number
18 and letter r. I cannot write the formula, I need
someone to give me a details of how to do it.
Thanks, WAB
Assuming the number 1 is in A1, use =CHAR(A1+96) to
get an "a". If you pass
2, it will return "b".
/Fredrik
.
|