I have a time study data set that has three different order types and resulting times to fulfill that order. An Order Type will be entered into
C8. In cells
C9:C, I want to create an auto-updating list of Fulfillment Times that are correlated to the Order Type in
C8 can say "Custom" and
C9:C will vertically list Fulfillment Times 0:12:00, 0:13:00, 0:14:00. If I change C8 to "Kit",
C9:C will list 0:07:00.
I know there's a simple solution, but I'm having a hard time figuring it out.