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!
|