| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto fill of columns
Create a table on another worksheet and then you can use =vlookup() to return
those other fields. You may want to read Debra Dalgleish's notes: http://www.contextures.com/xlFunctions02.html linstock wrote: I'm trying to create a spreadsheet where I can enter a person's name and it will automatically enter their department and charge number. Is there any way to do this? Thanks. -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom auto fill question | Excel Discussion (Misc queries) | |||
| Auto Fill Series when number ends in -1 | Excel Discussion (Misc queries) | |||
| Auto Fill workshseet tabs? | Excel Discussion (Misc queries) | |||
| auto filling columns from rows | Excel Discussion (Misc queries) | |||
| what is keyboard shortcut to auto fill option | Excel Discussion (Misc queries) | |||
Threaded Mode
