Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
account # entry needs to return the account description
I need to create a shreadsheet were one column is a 4 digit # and that number
determines what the description is in the next column. The list could/would be 1000 or more in items to choose from. For example I know the inventory item # I need the description without having to look up each one individually. I am creating a form that is used several times per month from the same basic data, but will always be on different lines |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
account # entry needs to return the account description
See this:
http://contextures.com/xlFunctions02.html -- Biff Microsoft Excel MVP "placerpone" wrote: I need to create a shreadsheet were one column is a 4 digit # and that number determines what the description is in the next column. The list could/would be 1000 or more in items to choose from. For example I know the inventory item # I need the description without having to look up each one individually. I am creating a form that is used several times per month from the same basic data, but will always be on different lines |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TWO ACCOUNT MATCH | Excel Discussion (Misc queries) | |||
Account codes | Excel Worksheet Functions | |||
Can a service account be embedded in Workbook so that by default the macros are run with service account credentials and not the user credentials??? | Excel Discussion (Misc queries) | |||
Statement of Account | Excel Worksheet Functions | |||
automatic entering Balance at every entry in my bank account | Excel Discussion (Misc queries) |