I want to be able to Type in or select the Activity Code from a dropdown and be presented with a listing of the Wk Days that the activity occur and a listing of the activity/activity name using either arrays, filters, or some other formula that will accomplish the goal.
Pivot tables work but the layout is not how I'd like to present the data.
In my "Target Results" example (provided in the attachment), BC in cell G6 is what I'd type in or select from dropdown and the result would be a filtered listed of A2:C26, the end results would show only the week days and Activity (name) from the list based on the Activity code entered in G6.
NOTE: If the data (A2:C26) has to be made into a table or if it or the formula has to be moved to another sheet I'm ok with that
My primary data is a listing of application screens that impact other app screens, and some screens are impacted my multiple screens, my goal is to create a spreadsheet that will allow me to select a screen and see what screens are impacted.
See Sample Spreadsheet attached.