| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
