Yes, you can achieve this using the WordPress WP_Query and passing advanced custom fields to it with a meta query. Instructions on how to do this can be found here: https://www.advancedcustomfields.com/resources/query-posts-custom-fields
Brilliant, thanks for sharing this info. This is all very interesting 🙂