Excel Functions for Event Registration

I need to create a list of attendees for the various events I have had people register for a conference. The sheet I need made from is https://docs.google.com/spreadsheets/d/1eW1JgY0ELfhmIMDQTgBoFEDRttGdv8Y7VqYdbP7mQEk/edit?usp=sharing

In column BK lists what the person has purchased. I need formulas to return the names of each registrant.

Sunday Professional Tour 1 - Taconite Tour (full day)

Sunday Professional Tour 2 - PolyMet & Giant's Ridge (full day)

Wednesday Professional Tour 3 - Duluth Stream Restoration Tour (2 hours)

Thursday Professional Tour 4 - Peat Mining & Reclamation (full day)

Thursday Professional Tour 5 - Estuary Restoration Boat Tour (2 hours)

Monday Culture Tour 1 - Vista Boat Tour

Tuesday Culture Tour 2 - Glensheen Mansion Guided Tour

Wednesday Culture Tour 3 - Zephyr Train Tour

Monday Social Event & Dinner - Pier B at the Waterfront

Wednesday GeoFluv Geomorphic Reclamation Workshop

Wednesday Mine Subsidence Workshop

Wednesday Early Career Professionals' Event


The formula should return the first name, last name, email, phone number IF the person has registered for the event (based on text in column BK). Each event should have it's own page/tab on the excel document.