Auto populate a cell based off a look up table

J

jrt

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Populate a Field 1
How do I set up a column to populate... 3
How do I auto populate based on a drop down list? 0
Populate subform based on non recordsource derived data. Is it possible? 2
Looking up a worksheet and value 2
Array - Count based on 3 conditions 1
Auto Populate Based on Other Selection 2
Stubborn Array won't Populate from single ADODB.Connection Query 4

Top