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

Vlookup and If function 10
Payroll,formulas and Macros? 2
Help with Look Up with multiple complex conditions 2
How did I populate other cells based on infor from one cell? 2
combo box with parent table 2
Auto Populate a Field 1
Auto-Numbering in a Table in MS Word 1
Auto Populate & Name Recognition 1

Top