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.

For example, 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.

enter image description here

  • 1
    Welcome to Web Applications. Try the built-in function FILTER. If you need further help add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Jun 10 '20 at 5:14

You can use the following query formula

=QUERY(A2:B6,"select B where A= ' "&C1&" ' ")

Pro tip:

To take it further.
Notice the little triangle on the right side of cell C1? We can apply Data Validation in the word search cell with List of items using Custom,Kit,Basic

(Please do adjust ranges to your needs)

enter image description here

Functions used:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.