Is there a way

[mspatton]

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?

 

[IanC]

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

 

[Gary''s Student]

Create a VLOOKUP() table.

See:

http://www.contextures.com/xlFunctions02.html

 

[SCrowley]

=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.

 

[SCrowley]

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

 

[SCrowley]

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