Spreadsheet: 767877d1644687802-formula-to-copy-rows-based-on-on-three-different-criteria-extract-multiple-matches-from-same-column
Sheet: OUTCOME

Ref | Location | Text 1 | Full Name | First Name | Surname | email | Category |  | State? |  | Ref | Location | Text 1 | Full Name | First Name | Surname | email | Category |  | Location
 | PAR | dolor sit amet, consectetur adipiscing elit | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Critical |  | PAR |  |  | PAR | dolor sit amet, consectetur adipiscing elit | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Critical |  | NY
DPS-005 | MAD | sed do eiusmod tempor incididunt ut labore et [NAME]. | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Moderate |  |  |  | DPS-008 | PAR | [NAME] et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | George | [NAME] | [NAME] | High |  | LON
DPS-006 | NY | Ut enim ad minim veniam | Freddie Booth | Freddie | Booth | freddie [EMAIL] | Moderate |  |  |  | DPS-015 | PAR | aliquip ex ea commodo consequat. | [NAME] | [NAME] | Barnes | [NAME] | Critical |  | PAR
DPS-007 | NY | Quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | [NAME] | [NAME] [EMAIL] | Critical |  |  |  | DPS-018 | PAR | Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Butler | mia [EMAIL] | High |  | MUN
DPS-008 | PAR | [NAME] et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | George | [NAME] | [NAME] | High |  |  |  | DPS-021 | PAR | consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Adams | [NAME] | Critical |  | MAD
DPS-009 | MUN | [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Grace | [NAME] | grace [EMAIL] | Moderate
DPS-012 | LON | quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Chapman | isabella [EMAIL] | High
DPS-013 | LON | exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Isla | [NAME] | isla [EMAIL] | Moderate
DPS-015 | PAR | aliquip ex ea commodo consequat. | [NAME] | [NAME] | Barnes | [NAME] | Critical
DPS-016 | NY | [NAME] et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | Leo | Bailey | leo [EMAIL] | Moderate
DPS-018 | PAR | Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Butler | mia [EMAIL] | High
[NAME] | LON | [NAME], quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Atkinson | [NAME] [EMAIL] | Moderate
DPS-021 | PAR | consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Ut enim ad minim veniam, quis nostrud exercitation ullamco [NAME] ut aliquip ex ea commodo consequat. | [NAME] | [NAME] | Adams | [NAME] | Critical
 |  | Formula in A2 finds all records in the Source Data worksheet matching the three Criteria and lists them. |  |  |  |  |  |  | "Unique" Locations listed in Col U and set as Dynamic Range.
 |  |  |  |  |  |  |  |  | Cell J2 set as DropList.
 |  |  |  |  |  |  |  |  | Select a Location from the DropList, and formua in L2 lists all the matching records in the Source Data worksheet