| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto populate a cell based off a look up table
Hi, I am creating a worksheet with a drop down menu for staff to choose their
Department name and I want a corresponding column (Dept #) to auto populate depending on which dept name is chosen from the look up table. LOOK UP TABLE: DEPARTMENT # Admin - General 010401 Admin - Fundraising 070401 Latino Team 123401 WORKSHEET FOR STAFF TO ENTER DEPT INFO (example below): So when a staff chooses Admin - General as the Dept Name (from a drop down list feeding off the above look up table), the Dept # will auto populate with the # from the above look up table. Dept Name Dept # Admin - General 010401 (auto-populated) Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto populate a cell based off a look up table
=VLOOKUP("Admin - General",A2:B100,2,0)
"jrt" wrote: Hi, I am creating a worksheet with a drop down menu for staff to choose their Department name and I want a corresponding column (Dept #) to auto populate depending on which dept name is chosen from the look up table. LOOK UP TABLE: DEPARTMENT # Admin - General 010401 Admin - Fundraising 070401 Latino Team 123401 WORKSHEET FOR STAFF TO ENTER DEPT INFO (example below): So when a staff chooses Admin - General as the Dept Name (from a drop down list feeding off the above look up table), the Dept # will auto populate with the # from the above look up table. Dept Name Dept # Admin - General 010401 (auto-populated) Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto populate a cell based off a look up table
Perfect...thank you!
"Teethless mama" wrote: =VLOOKUP("Admin - General",A2:B100,2,0) "jrt" wrote: Hi, I am creating a worksheet with a drop down menu for staff to choose their Department name and I want a corresponding column (Dept #) to auto populate depending on which dept name is chosen from the look up table. LOOK UP TABLE: DEPARTMENT # Admin - General 010401 Admin - Fundraising 070401 Latino Team 123401 WORKSHEET FOR STAFF TO ENTER DEPT INFO (example below): So when a staff chooses Admin - General as the Dept Name (from a drop down list feeding off the above look up table), the Dept # will auto populate with the # from the above look up table. Dept Name Dept # Admin - General 010401 (auto-populated) Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Populate Based on Other Selection | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
Linear Mode
