Automatically fill in table based on drop down menu per row

Occasional Contributor



I'm trying to improve my teams' working schedule. In the drop down menus, people can choose their names to register themselves. 


We usually work 4h shifts, so in the next table I would like to automatically fill in 4 when someone fills in their name. Column A has all the names of our team members.


I tried it with =IF(B:B=A41;4;0) but that doesn't work. It works when I do =IFS(B9=A41;4;0;B12=A41;4;0, etc), but that is a lot of work. 


Is there a way to do this easily?


Thanks in advance!


9 Replies


Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.

Hopefully this works. Thank you for taking the time to look into it!


I get "Access Denied". You'll have to get a link that allows viewing/downloading the workbook.

I changed the settings, does it work now?


Yes, I have downloaded the workbook and I'll take a look.

Thank you for taking the time to look into it!


See the attached version.

Thank you so much! That's great!