How to make drop down menu by showing staff name and staff id ?

Xani · Jun 25th 2021

Hello

I am trying to make Dropdown menu by selecting staff name from Employee Name & It will show directly staff number next to it.

I try to do but I couldn't understand the way.

Regards

**royUK** · Jun 25th 2021

I've converted the Staff List to a Table - Overview of Excel tables
A Named Range based on the Table is used for the Data Validation List. This allow you to ADD OR REMOVE STAFF AND THE LIST AUTOMATICALLY UPDATES.
A VLOOKUP formula populates the Staff Number.

I have added this to January's section. The other sections can be completed by copy and paste.

Xani · Jun 25th 2021

Thank u a lot , I will try it

**royUK** · Jun 26th 2021

Post back if you need help.

Participate now!