Extract text cells if matches one or two criteria

[Didier67]

Hello, first of all, sorry for my english and sorry i can't put photos here (don't know why but does'nt work)... 

1. I did a template (date base) in wich each office will add their goals on each priority types. 

Example (here are the three columns):   

SELECT OFFICE,       SELECT PRIORITY TYPE,       ADD GOALS

    QUEBEC                RECRUITMENT                COMPLETE 3 PROMOTING CAREER ACTIVITIES

2. On the second page, i want to select wich of the office and wich of priority type (lists are already done) and be able to extract each goals in a list. Like if the boss want to see wich goals ar per office or priority type, on a list. 

 What formula can i use to extract all goals from priority type and or offices ?

Thank you very much community.

Pier-Olivier

[#2]

@Didier67 See the attached workbook for a solution as I understand your request.

As the selection can be made using Office and/or Priority Type, there are three separate FILTER functions within nested IF functions.  I created most formulas with a limit of 1,000 entries on the Combined Data worksheet, but that limit can be readily increased.

(You did not include much sample data, so don't be surprised at what I came up with. :grinning_face: )