| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Functions
This is what I want to do:
For my time cards we have work code #'s and code descriptions. For ex. Description Work Code Wall-Rough 1234567 When I type in the work code I want the description to automatically display in the cell next to it. Can this be done? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Functions
As long as you have a table of ids and descriptions, you can use VLOOKUP.
Check help. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "OUSoonersgirl" wrote in message ... This is what I want to do: For my time cards we have work code #'s and code descriptions. For ex. Description Work Code Wall-Rough 1234567 When I type in the work code I want the description to automatically display in the cell next to it. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
| Improvements for text finding functions | Excel Discussion (Misc queries) | |||
Hybrid Mode
