I am new to excel and I need some help. I have seen it done before where you
can "relate" 2 cells together, but still keeping them in their own respective
cells. My problem is this, I have a column of scores and a coulmn of names. I
would like to be able to type in a score and have the name appear next to it
automatically by means of some formula. Is this a complicated as I am making
it? I have used many functions but still cannot find a remedy to typing in
each name by hand. I would like the list to have the capability to grow also,
so I could enter more names and scores..I appreciate your time taken to read
and respond to this.
Thank You a thousand times over.

have a look in the help index for LOOKUP and VLOOKUP

--
Don Guillett
SalesAid Software

"Levi" wrote in message
...
I am new to excel and I need some help. I have seen it done before where
you
can "relate" 2 cells together, but still keeping them in their own
respective
cells. My problem is this, I have a column of scores and a coulmn of
names. I
would like to be able to type in a score and have the name appear next to
it
automatically by means of some formula. Is this a complicated as I am
making
it? I have used many functions but still cannot find a remedy to typing in
each name by hand. I would like the list to have the capability to grow
also,
so I could enter more names and scores..I appreciate your time taken to
read
and respond to this.
Thank You a thousand times over.

Hi Levi
If name is in A1 and number is in B1
Try this in C1:

=A1&B1

If you want a space between them use:

=A1&" "&B1

HTH
Michael

"Levi" wrote:

I am new to excel and I need some help. I have seen it done before where you
can "relate" 2 cells together, but still keeping them in their own respective
cells. My problem is this, I have a column of scores and a coulmn of names. I
would like to be able to type in a score and have the name appear next to it
automatically by means of some formula. Is this a complicated as I am making
it? I have used many functions but still cannot find a remedy to typing in
each name by hand. I would like the list to have the capability to grow also,
so I could enter more names and scores..I appreciate your time taken to read
and respond to this.
Thank You a thousand times over.