| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically entering data
Good afternoon!
I would like to find a way to automatically attach a client name to a client number. For instance, if client is called "thisismyclient", and his client number is 00001, is there a way in the spreadsheet to automatically populate the correct name by just typing in the client number? Many thanks! PS, I work on Excel 2003. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically entering data
hi
yes there is....with a lookup formula. but.... you have to have a table of client names and corrosponding client numbers that the formula can reference. in xl help read up on lookup formulas. or... you can download a file that explains most xl formulas http://www.xlfdic.com/ Regards FSt1 "Beverly" wrote: Good afternoon! I would like to find a way to automatically attach a client name to a client number. For instance, if client is called "thisismyclient", and his client number is 00001, is there a way in the spreadsheet to automatically populate the correct name by just typing in the client number? Many thanks! PS, I work on Excel 2003. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically entering data
Thank you so much! Very helpful and will save me a lot of hassle in the
future! Bev "FSt1" wrote: hi yes there is....with a lookup formula. but.... you have to have a table of client names and corrosponding client numbers that the formula can reference. in xl help read up on lookup formulas. or... you can download a file that explains most xl formulas http://www.xlfdic.com/ Regards FSt1 "Beverly" wrote: Good afternoon! I would like to find a way to automatically attach a client name to a client number. For instance, if client is called "thisismyclient", and his client number is 00001, is there a way in the spreadsheet to automatically populate the correct name by just typing in the client number? Many thanks! PS, I work on Excel 2003. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Entering Values | Excel Worksheet Functions | |||
| exit cell automatically after entering data | Excel Worksheet Functions | |||
| Entering calendar automatically | Excel Worksheet Functions | |||
| Move to next unprotected cell automatically after entering data | Excel Discussion (Misc queries) | |||
| Sorting dataset automatically after entering data in a row [or cel | Excel Discussion (Misc queries) | |||
Linear Mode
