Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Contents in cells
We are using a drop down list for a column. Under the main body of the
spreadsheet is the same list with an explanation of the code used. Is there any way to add contents to all the cells in the column automatically to reflect the proper code from the list. Thank you in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Contents in cells
Maybe you can use an adjacent column to return the explanations of the code
based on a table and an =vlookup() formula: Debra Dalgleish has some notes: http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://www.contextures.com/xlFunctions03.html (for =index(match())) Mike Busch wrote: We are using a drop down list for a column. Under the main body of the spreadsheet is the same list with an explanation of the code used. Is there any way to add contents to all the cells in the column automatically to reflect the proper code from the list. Thank you in advance -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging cells and keeping their contents | Excel Discussion (Misc queries) | |||
find value and paste contents of cells | Excel Discussion (Misc queries) | |||
Insert contents of various cells in a column into one cell? | Excel Discussion (Misc queries) | |||
Clearing the Contents of Merged Cells | New Users to Excel | |||
how to delete contents of cells having specific data | Excel Discussion (Misc queries) |