Using Lookup and multivalued fields in queries - Microsoft Support
https://support.microsoft.com:443/en-gb/office/using-lookup-and-multivalued-fields-in-queries-6f64f92d-659f-411c-9503-b6624e1e323a
WEBDrag the fields you to the query grid. In this example, drag the Title field and the AssignedTo multivalued field. In the query grid, under AssignedTo, in the Criteria row, enter "Kelly Rollin" AND "Lisa Miller". On the Design tab, in the Results group, click Run.
DA: 89 PA: 13 MOZ Rank: 79