Evaluating a specified array for 2 (or more) criteria and returning a value

So, I feel like this is a bit different from your typical INDEX/MATCH array function, but maybe not.

Essentially, the data shows 4 Procedure Categories:
- Office Visit
- Covid Test
- Covid Vaccine
- Not Specified

A patient can have Office Visit with no Covid Test, or an Office Visit with Covid Vaccines. The "Not Specified" category is negligible, but I'd still like to show it.

The request is to show patients with a combination of "Office Visit" and "Covid Test" by having the 2 occur in the same visit. Here is my sample data attached.

Ideally, I'd like to separate Office Visits Only, Covid Vaccines Only, and Office Visits with a Covid Test. Any help is appreciated!