Excel Formula Help? I am confused about this question and how you would solve it using a formula

"Am I able to contact the ones who have not RSVPed? Can I use their email, phone or both?"

H 34224 1-903-410-8485 1-885-374-17706 1-906-526-9187 1-321-360-9675 284-2452 Placerat Avenue 8474 Purus. Pove 897-1969 Suspendisse Ap 1930-3312 Orci Avenue 7342 No Yes Yes No Yes No Maglie 3510 71714 69995 20235 51018 Yes Yes Yes Yes Yes 76057 Yes Yes rhoncus. Donec vitaemauris.edu Sed molestederatedu elit. Curabiturgin.ca amatiscutulant egestas aduldunecedu Nula placerator eget laoreet Vivamus molestedapibus.net nec tempus Donec.co.uk Nula velnisl.com dictum nequeuedu beronecporttitortellus.ca vestibulum nequeociosquadca psum. non arotempus.ca non magna. Namtortoratrisus.com hendrerit neque egestas.org luctus nequetelusimperdiet.edu stomare.co.uk sem vitae tulla.com massa risusvarusordnet gulavesi bulumlorem.co.uk molestie sodales habitant.edu Cras sed sagittis net diam. Duis mi pedeNunc.co.uk Vestibulum ante ipsum Mauriomolestie.co.uk tincidunt congue turpis nonluctus.edu feugiat placerat vel Praesentou.co.uk 1-836-871-0050 1-548-415-1900 1-701-703-2161 1-900-246-3112 1-836-605-6622 1-774-812-8921 1-747-245-8252 1-517-601-0019 1-962-227-0778 1-387-461-1963 1-379-730-5201 1-718-125-5021 1-470-412-2013 1-736-677-8505 1-869-135-1400 1-156-351-8682 1-173-751-1672 -977-956-5640 1-565-624-0697 1-313-133-6051 1-427-706-2564 59850 40418 357497 957532 718917 21405 40512 1-815-592-3810 1-965-161-9975 1-796-847-1485 1-737-967-4544 1-121-854-0207 1-193-630-7797 1-679-543-4074 1781156-6043 1-506-122-5171 1-221-892-8357 PO Box 68,2576 Nuno Street 579-8198 Qulis Rd 145 Velt. Avenue PO Box 212.3708 Alque Rd 1403 Les Ave 821-3058 Amet Am Ap #297-8460 Eget up 7490 Pede. St PO Box 40.96 Nuts Street PO Box 435,425 Dolor, Street 797-2380 Rhoncus Rd Ap 70-2041 Molestie. Street Ap 1000-6061 Ut St Ap 1697-3521 Semper Avenue PO Box 498,6481 Odio St 7777 Fermentum Av 306-424 Dictum St. 726-1336 AL SE PO Box 382.8222 Malesuada PO Box 742 312 Nunc St 895 Vestibulum St 812-7733 Scelerisque Ave PO Box 811, 1472 Cras Street PO Box 157,728 Turpis Road PO Box 120, 2473 Nung Road 2014 Lacus Rd Ap 243-0554 Eros Rd PO Box 480.530 Unna Road 30-1242 Tincidunt Ave PO Box 48,5106 Dictum. Avenue 5218 Semper Ap 259-6MY USE 1423 Feugiat Rond PO Box 767,9548 AmetRd. 4820 Mauris. Avenue 3383 Rius, St Ap 795-3677 Susi, Road PO Box 701,438 Donec Ave PO Box 126.2591 Cursus. Rd. Ap 1926-7850 Diam Rd 820-76549 Dictum 353-7248 Lorem, Road 896-617 Mauris Street 971 Lobortis St. PO Box 200,979 Integer Street 1935 Est Street PO Box 245, 113 in Love Ap 1953-9921 Tempus St Ap 687-7713 Scelerisque Road Ap 261-7802 Maecenas Rd. 10129 22133 290796 6537 104723 549403 8027 1451 Snaaskerke Macao Forbach Aland Islands 5640 RV Sankt Wendel Belgium But Westem Sahara 25130 Padang Sidempuan Saint Helena, Ascension Ecuador Foz do Iguu Cyprus El Tabo Bosnia and Herzegovina New Haven Bangladesh Nederokkerzeel Tanzania 5015 VF Brixton Saint Vincent and The Nus Costa Rica 23861 Albiano French Polynesia Wiliams Lake Croatia Groot-Gerau Tunisia 51544-99995 Gwangyang 25185 King's Lym Entras Wekweti Curaao Ayas Andorra Cagi Jordan Khaipur Cambodia Brentwood Antigua and Barbuda 20101 Forli Korea, North Koszalin Mai Artana Mauritius Katchi Azerbaijan Newmarket Cote D'Ivoire (Ivory Com Krasnogorsk Lebanon Fladelfia Western Sahara Brdington Brunel Tolentino Cameroon Valcourt Antarctica VIX 6 Hollogne-sur-Geer Slovakia Cras Averas Benin Lourdes Korea, North San Esteban Sri Lanka Esslingen Samoa 2003 KG Alken Croatia Kenny 0015 QT Sohbarpur Uganda North Shore Christmas Island Leut Indonesia Wibrin Honduras Vialky Liechtenstein 29989 St David's Burkina Faso Husum Tanzania 75646-260 Cisterna d Latina Dominica Edmonton Colombia Geertruidenberg Sint Maarten Cambiago Norfolk Island 25-807 Medan Norway Fossato Serralta Faroe Islands 1250 MV Chelwynd Madagascar Karlsruhe Kinkhan Liechtenstein 902769 736963 963881 21170 metus. Vivamus euismod veltras.net magna nec quam ante Vivamusnon.org egestas scelerisque ultricesem.edu Nulam lobortis quant dictum sapiens mag niet lobortis nisl nibh null or ante lectus.comisicummi.org vitae erat velCum.co.uk nislepenatibusetmagnis.co.uk bero.est.congue malesuada edu mique magna.org uma habitant.ca sorbconsectetuer.org turnator Mauris blandinecord.co.uk enim Mauris vulputatedu.org mauris. Integer pede.org doloredante.com habitant morbin.net semper.egestasOuism.com quam elementum arcu.edu Sed nec purustelus.net Cum sociis natoque tincidunt.co.uk Sed nuncmimet turpis ulamcorper.ca ligula. Nullam enim inciduntDonec.edu et magnis dis egestashendrert.org incidunt nunc egestas landtm.org No Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Awaiting Response Yes Yes Yes No No Yes No No Yes Yes Yes Awaiting Response Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Awaiting Response Yes Yes Yes 69465 156-272-37188 1-224-568-0009 564064 450 3386 50877 9811 - 165-232-3605 1-862-767-6700 1-223-23-5031 1-889-615-4707 1-674-343-5981 1-385-590-3701 1-102-775-1870 1-945-962-7309 1-468-595-1156 1-151-123-1739 1-691-471-9092 1-967-27-2013 1-266-219-3552 535171 JOS 838166 98711 4272 400516 H 34224 1-903-410-8485 1-885-374-17706 1-906-526-9187 1-321-360-9675 284-2452 Placerat Avenue 8474 Purus. Pove 897-1969 Suspendisse Ap 1930-3312 Orci Avenue 7342 No Yes Yes No Yes No Maglie 3510 71714 69995 20235 51018 Yes Yes Yes Yes Yes 76057 Yes Yes rhoncus. Donec vitaemauris.edu Sed molestederatedu elit. Curabiturgin.ca amatiscutulant egestas aduldunecedu Nula placerator eget laoreet Vivamus molestedapibus.net nec tempus Donec.co.uk Nula velnisl.com dictum nequeuedu beronecporttitortellus.ca vestibulum nequeociosquadca psum. non arotempus.ca non magna. Namtortoratrisus.com hendrerit neque egestas.org luctus nequetelusimperdiet.edu stomare.co.uk sem vitae tulla.com massa risusvarusordnet gulavesi bulumlorem.co.uk molestie sodales habitant.edu Cras sed sagittis net diam. Duis mi pedeNunc.co.uk Vestibulum ante ipsum Mauriomolestie.co.uk tincidunt congue turpis nonluctus.edu feugiat placerat vel Praesentou.co.uk 1-836-871-0050 1-548-415-1900 1-701-703-2161 1-900-246-3112 1-836-605-6622 1-774-812-8921 1-747-245-8252 1-517-601-0019 1-962-227-0778 1-387-461-1963 1-379-730-5201 1-718-125-5021 1-470-412-2013 1-736-677-8505 1-869-135-1400 1-156-351-8682 1-173-751-1672 -977-956-5640 1-565-624-0697 1-313-133-6051 1-427-706-2564 59850 40418 357497 957532 718917 21405 40512 1-815-592-3810 1-965-161-9975 1-796-847-1485 1-737-967-4544 1-121-854-0207 1-193-630-7797 1-679-543-4074 1781156-6043 1-506-122-5171 1-221-892-8357 PO Box 68,2576 Nuno Street 579-8198 Qulis Rd 145 Velt. Avenue PO Box 212.3708 Alque Rd 1403 Les Ave 821-3058 Amet Am Ap #297-8460 Eget up 7490 Pede. St PO Box 40.96 Nuts Street PO Box 435,425 Dolor, Street 797-2380 Rhoncus Rd Ap 70-2041 Molestie. Street Ap 1000-6061 Ut St Ap 1697-3521 Semper Avenue PO Box 498,6481 Odio St 7777 Fermentum Av 306-424 Dictum St. 726-1336 AL SE PO Box 382.8222 Malesuada PO Box 742 312 Nunc St 895 Vestibulum St 812-7733 Scelerisque Ave PO Box 811, 1472 Cras Street PO Box 157,728 Turpis Road PO Box 120, 2473 Nung Road 2014 Lacus Rd Ap 243-0554 Eros Rd PO Box 480.530 Unna Road 30-1242 Tincidunt Ave PO Box 48,5106 Dictum. Avenue 5218 Semper Ap 259-6MY USE 1423 Feugiat Rond PO Box 767,9548 AmetRd. 4820 Mauris. Avenue 3383 Rius, St Ap 795-3677 Susi, Road PO Box 701,438 Donec Ave PO Box 126.2591 Cursus. Rd. Ap 1926-7850 Diam Rd 820-76549 Dictum 353-7248 Lorem, Road 896-617 Mauris Street 971 Lobortis St. PO Box 200,979 Integer Street 1935 Est Street PO Box 245, 113 in Love Ap 1953-9921 Tempus St Ap 687-7713 Scelerisque Road Ap 261-7802 Maecenas Rd. 10129 22133 290796 6537 104723 549403 8027 1451 Snaaskerke Macao Forbach Aland Islands 5640 RV Sankt Wendel Belgium But Westem Sahara 25130 Padang Sidempuan Saint Helena, Ascension Ecuador Foz do Iguu Cyprus El Tabo Bosnia and Herzegovina New Haven Bangladesh Nederokkerzeel Tanzania 5015 VF Brixton Saint Vincent and The Nus Costa Rica 23861 Albiano French Polynesia Wiliams Lake Croatia Groot-Gerau Tunisia 51544-99995 Gwangyang 25185 King's Lym Entras Wekweti Curaao Ayas Andorra Cagi Jordan Khaipur Cambodia Brentwood Antigua and Barbuda 20101 Forli Korea, North Koszalin Mai Artana Mauritius Katchi Azerbaijan Newmarket Cote D'Ivoire (Ivory Com Krasnogorsk Lebanon Fladelfia Western Sahara Brdington Brunel Tolentino Cameroon Valcourt Antarctica VIX 6 Hollogne-sur-Geer Slovakia Cras Averas Benin Lourdes Korea, North San Esteban Sri Lanka Esslingen Samoa 2003 KG Alken Croatia Kenny 0015 QT Sohbarpur Uganda North Shore Christmas Island Leut Indonesia Wibrin Honduras Vialky Liechtenstein 29989 St David's Burkina Faso Husum Tanzania 75646-260 Cisterna d Latina Dominica Edmonton Colombia Geertruidenberg Sint Maarten Cambiago Norfolk Island 25-807 Medan Norway Fossato Serralta Faroe Islands 1250 MV Chelwynd Madagascar Karlsruhe Kinkhan Liechtenstein 902769 736963 963881 21170 metus. Vivamus euismod veltras.net magna nec quam ante Vivamusnon.org egestas scelerisque ultricesem.edu Nulam lobortis quant dictum sapiens mag niet lobortis nisl nibh null or ante lectus.comisicummi.org vitae erat velCum.co.uk nislepenatibusetmagnis.co.uk bero.est.congue malesuada edu mique magna.org uma habitant.ca sorbconsectetuer.org turnator Mauris blandinecord.co.uk enim Mauris vulputatedu.org mauris. Integer pede.org doloredante.com habitant morbin.net semper.egestasOuism.com quam elementum arcu.edu Sed nec purustelus.net Cum sociis natoque tincidunt.co.uk Sed nuncmimet turpis ulamcorper.ca ligula. Nullam enim inciduntDonec.edu et magnis dis egestashendrert.org incidunt nunc egestas landtm.org No Yes Yes Yes Yes No Yes Yes Yes No Yes Yes Yes Yes Awaiting Response Yes Yes Yes No No Yes No No Yes Yes Yes Awaiting Response Yes Yes Yes No Yes No Yes Yes Yes Yes Yes Awaiting Response Yes Yes Yes 69465 156-272-37188 1-224-568-0009 564064 450 3386 50877 9811 - 165-232-3605 1-862-767-6700 1-223-23-5031 1-889-615-4707 1-674-343-5981 1-385-590-3701 1-102-775-1870 1-945-962-7309 1-468-595-1156 1-151-123-1739 1-691-471-9092 1-967-27-2013 1-266-219-3552 535171 JOS 838166 98711 4272 400516