Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have have one column's input depend on the variables in a second one?
I would like to have a set of names assigned to certain numbers for inventory
purposes, such as, each time that '12345' is typed in any row in the first column the corresponding row of the second column will say 'Product A.' It would also have to respond in such a way that if '34567' is typed in the same location, 'Product D' would be displayed. Thanks for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have have one column's input depend on the variables in
The feature you're looking for is called VLOOKUP........check out the HELP
section for "VLOOKUP worksheet function" and give it a try........post back here if you need any help. Vaya con Dios, Chuck, CABGx3 "willb" wrote: I would like to have a set of names assigned to certain numbers for inventory purposes, such as, each time that '12345' is typed in any row in the first column the corresponding row of the second column will say 'Product A.' It would also have to respond in such a way that if '34567' is typed in the same location, 'Product D' would be displayed. Thanks for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have have one column's input depend on the variables in
That worked nice... I have to make sure all future inputs will be sequencial
though. I listed the products like schools make their course outlines: Freshman comp - 101, Brit Lit - 102, leave some room/skip a few, Am Lit 110... . I have the spaces in there to add the names that I don't have the numbers for yet. Thanks for the help my friend. -Will CLR wrote: The feature you're looking for is called VLOOKUP........check out the HELP section for "VLOOKUP worksheet function" and give it a try........post back here if you need any help. Vaya con Dios, Chuck, CABGx3 I would like to have a set of names assigned to certain numbers for inventory purposes, such as, each time that '12345' is typed in any row in the first [quoted text clipped - 3 lines] Thanks for any help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I have have one column's input depend on the variables
You're welcome Will, thanks for the feedback. And, be sure to check out the
last option on the VLOOKUP formula, "FALSE", for it searches only for exact matches... Vaya con Dios, Chuck, CABGx3 "willb" wrote: That worked nice... I have to make sure all future inputs will be sequencial though. I listed the products like schools make their course outlines: Freshman comp - 101, Brit Lit - 102, leave some room/skip a few, Am Lit 110... . I have the spaces in there to add the names that I don't have the numbers for yet. Thanks for the help my friend. -Will CLR wrote: The feature you're looking for is called VLOOKUP........check out the HELP section for "VLOOKUP worksheet function" and give it a try........post back here if you need any help. Vaya con Dios, Chuck, CABGx3 I would like to have a set of names assigned to certain numbers for inventory purposes, such as, each time that '12345' is typed in any row in the first [quoted text clipped - 3 lines] Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Text to Columns" for many columns in Excel 2003 | Excel Discussion (Misc queries) | |||
Counting values for variables in separate columns | Excel Discussion (Misc queries) | |||
Merging two columns and keeping the data from both | Excel Worksheet Functions | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |