I'm creating a new sheet to assign shifts for my employees. I want to have a
drop down in one cell where I can pick shift times then in the next cell,
have the hours automatically picked in assiciation with the shift. I've
already created the drop down using validation but am not sure how to get the
second cell to automatically picks the hours associated with the shift. Is
this a vlookup function or other?