List default based on users information

[LanceParks]

Can I have some help please? (See attached image)

I have 3 tabs. the first sheet has employee’s data. UserID, Name and Level

Second sheet is where I want the help. There sheet shows the users name and level, the level cell is a dropdown list containing all the possible levels. (The list values come from the third sheet that holds the list data.)

I would like when the sheet is loaded, that the users default level (level 3) is selected from the employee’s data.

How can I achieve this please?

Thanks in advance

 

[LanceParks]

populate default value.xlsx
	A	B	C	D
1	Sheet 1
2	385	Smith, David	Level 3
3
4	Sheet 2
5		Smith, David	Level 3
6
7	Sheet 3
8	List
9	Level 1
10	Level 2
11	Level 3
12	Level 4
13	Trade
14	Supervisor
15	Deputy
16	Co-ordinator
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
B5:C5	List	=$A$9:$A$16