Is there a way
 

I have a list of clients who all have their own Customer number. Is there a
way to tie the name and number together so that when I type their number into
a cell the name comes up in the cell next to it?

Is there a way
 

Without knowing the arrangement of your data, I don't know exactly, but have
a look at VLOOKUP (or HLOOKUP).

--
Ian
--
"mspatton" wrote in message
...
I have a list of clients who all have their own Customer number. Is there
a
way to tie the name and number together so that when I type their number
into
a cell the name comes up in the cell next to it?

Is there a way
 

Create a VLOOKUP() table.

See:

http://www.contextures.com/xlFunctions02.html
--
Gary''s Student - gsnu200803


"mspatton" wrote:

I have a list of clients who all have their own Customer number. Is there a
way to tie the name and number together so that when I type their number into
a cell the name comes up in the cell next to it?

Is there a way
 

=LOOKUP(E18,($EE$7:$EE34),($EC$7:$EC$34))

Cell E17 is the cell where your type the number
Cell E18 is where the formula goes and returns your answer

Column EE is a list of all the customer names (be sure they are alphabetized)
Column EC is a list of all the corresponding customer numbers.

so
=LOOKUP(E18 =Cell next to where you type your number,($EE$7:$EE34)= your
list of names,($EC$7:$EC$34)= your list of corresponding numbers)and the
extra ) finishes it.

--
Thank you,

scrowley(AT)littleonline.com


"mspatton" wrote:

I have a list of clients who all have their own Customer number. Is there a
way to tie the name and number together so that when I type their number into
a cell the name comes up in the cell next to it?

Is there a way
 

Of course, you'll substitute the correct cell addresses as they pertain to
your spreadsheet.
--
Thank you,

scrowley(AT)littleonline.com


"SCrowley" wrote:

=LOOKUP(E18,($EE$7:$EE34),($EC$7:$EC$34))

Cell E17 is the cell where your type the number
Cell E18 is where the formula goes and returns your answer

Column EE is a list of all the customer names (be sure they are alphabetized)
Column EC is a list of all the corresponding customer numbers.

so
=LOOKUP(E18 =Cell next to where you type your number,($EE$7:$EE34)= your
list of names,($EC$7:$EC$34)= your list of corresponding numbers)and the
extra ) finishes it.

--
Thank you,

scrowley(AT)littleonline.com


"mspatton" wrote:

I have a list of clients who all have their own Customer number. Is there a
way to tie the name and number together so that when I type their number into
a cell the name comes up in the cell next to it?

Is there a way
 

I forgot to tell you that the formula is an ARRAY formula. Once you type in
the formula hit CLT+SHIFT+Enter
--
Thank you,

scrowley(AT)littleonline.com


"IanC" wrote:

Without knowing the arrangement of your data, I don't know exactly, but have
a look at VLOOKUP (or HLOOKUP).

--
Ian
--
"mspatton" wrote in message
...
I have a list of clients who all have their own Customer number. Is there
a
way to tie the name and number together so that when I type their number
into
a cell the name comes up in the cell next to it?