Text in one cell pulls data from 2 cell next to it for each row

[antinora]

Greetings Mr. Excel forum:

It's been a while as my role changed at work. However I'm looking for VBA suggestion/code. I want to scan each cell in column E looking for the word "MISSING" then once found report the text in the 2 column cells (C & D in this case) to the left on the same row for all rows.

Thanks and Happy Friday eve!

Below is sample data from my spreadsheet.

MrExcelUpload29OCT20 - Antinora.xlsx
	A	B	C	D	E	F	G	H
1	Fname	Date	PD 1 Class	PD 1 Teacher	PD 1 Attendance	PD 2 Class	PD 2 Teacher	PD 2 Attendance
2	Aadesh	10/22/2020	PGS85-08	SAMUELSEN	P	HVS11QQT-01	MADIGAN HUSSAIN	P
3	Aakash	10/22/2020	FSS61-09	RAMIREZ	P	MGS21QQH-09	SANCHEZ	P
4	Aaliyah	10/22/2020	EES87QQT-03	VARGAS RIVERA	A	PQS85QF-02	AMALFITANO	P
5	Aamar	10/22/2020	HGS43QQX-05	SOTRIYADIS	P	KPS61T-02	JOSEPH	P
6	Aaron	10/22/2020	HGS41QQR-01	CAVER	MISSING	PQS85QV-02	MEDITZ	A
7	Aaron	10/22/2020	KPS61T-01	VALDEZ	P	EES85X-02	WOLF	A
8	Aaron	10/22/2020	EES81Q9T-01	SOLOMON GIBBONS	P	ZJPOPLIT-10	VARGAS RODRIGUEZ	P
9	Aarti	10/22/2020	SES21Q9-01	FEISER	P	PPS85-08	KUSHNICK	P
10	Abdalrahman	10/22/2020	SDS21QQM-01	MOHAN D	P	EES41QWA-02	MALINAUSKAS	A
11	Abdul	10/22/2020	SHS21QQH-01	SANDERS	P	ALS11U-01	SHERIDAN	P
12	Abdullah	10/22/2020	EES87QQT-03	VARGAS RIVERA	A	PGS85-02	SAMUELSEN	L
13	Abdulrahman	10/22/2020	EES81Q12-01	HASSAN	L	HGS41Q12-01	BANGAREE CHIARAPPA	P
14	Abel	10/22/2020	HGS43QQX-01	ROBERTSON	A	HUS21-04	LOVE	A
15	Abel	10/22/2020	EES85-01	WALLACE	P	MRS21H-01	CHEN	P
16	Abigail	10/22/2020	EES81Q9-01	MOHAN D	P	AES21-02	MARTI MUNOZ	P
17	Abraham	10/22/2020	EES85-01	WALLACE	P	SCS21U-01	PEREIRA	P
18	Abu	10/22/2020	MGS21-04	LUPO	P	SES21-02	BRAVSTEIN	P
19	Acleama	10/22/2020	PQS85QV-01	MEDITZ	P	MRS21H-01	CHEN	P
20	Adam	10/22/2020	MGS41Q9-01	FIORLETTA	A	MGS42Q9-01	FIORLETTA	P
21	Adam	10/22/2020	AYS21-02	SHERIDAN	P	MRS21H-01	CHEN	P
22	Adamaris	10/22/2020	AYS21-02	SHERIDAN	A	SCS21U-01	PEREIRA	P
23	Adamaris	10/22/2020	FSS43QQI-01	MONTAN	P	SCS21U-01	PEREIRA	P
24	Addie	10/22/2020	AYS21-02	SHERIDAN	A	SCS21U-01	PEREIRA	A
25	Adeena	10/22/2020	HVS11QQT-02	COHEN	P	ZJCOMSCI-01	HAN	L
26	Adilya	10/22/2020	PGS85-08	SAMUELSEN	A	SES21-02	BRAVSTEIN	A
27	Aditya	10/22/2020	EES43QWA-01	VALDEZ	P	PPS85-02	GERARD	P
28	Adna	10/22/2020	EES87QQM-01	PERKINS	P	AHS21-02	ALFARO	P
29	Adonis	10/22/2020	AYS21-02	SHERIDAN	P	PQS85QV-02	MAKSIMOVIC	P
30	Adrian	10/22/2020	PPS85-01	KUSHNICK	A	HUS21-04	LOVE	A
31	Adrian	10/22/2020	HVS11QQT-02	MADIGAN COSMA	A	ZJCOMSCI-01	MOTTOLA	A
32	Adrian	10/22/2020	MGS41Q9-01	FIORLETTA	A	MGS42Q9-01	FIORLETTA	A
33	Adrian	10/22/2020	SES21-01	BRAVSTEIN	P	HUS21-04	LOVE	P
34	Adrian	10/22/2020	PGS85-01	SCAROLA	P	EES81Q9-09	MOHAN D	P
35	Adriana	10/22/2020	MRS11QBT-01	CHEN LALL	A	HVS11QQT-01	MADIGAN HUSSAIN	A
36	Adriana	10/22/2020	MCS41X-01	WATSON	P	MCS42X-01	WATSON	P
37	Adriana	10/22/2020	PGS85-01	SCAROLA	P	FSS41QQL-01	BAEZ	P
38	Aeshah	10/22/2020	SHS21QQH-01	SANDERS	P	EES85X-02	CANZONERI COLIC	P
39	Afrida	10/22/2020	EES81Q9-01	SHARMA	P	MES41Q9-01	SOLOMON GIBBONS	P
40	Ahmed	10/22/2020	PQS85QF-01	AMALFITANO	P	EES85X-02	WOLF	P
41	Aidan	10/22/2020	PGS85-01	SCAROLA	P	FSS61-02	SHABANA	P
42	Aiden	10/22/2020	HGS41Q9T-01	MEIGHAN	P	ZJPOPLIT-02	WALLACE	A
43	Aiden	10/22/2020	MGS21-04	LUPO	P	EES85X-02	WOLF	P
44	Aila Marie	10/22/2020	EES41QWB-01	SCAROLA	P	SLS21QQL-03	SOLOMON GIBBONS	MISSING
45	Aishah	10/22/2020	HGS41QQR-01	CHEN LALL	MISSING	HGS43QDX-01	SOTIRYADIS DEVEAU	A
46	Akash	10/22/2020	APS21-01	MARTI MUNOZ	A	MGS21QQH-09	SANCHEZ	A
47	Akelia	10/22/2020	PHS11-01	FOUNTOULIS	A	SES21QQT-01	SULTAN PAK	A
48	Aklema	10/22/2020	RZS22-01	NEWMAN	P	ZJCOMSCI-01	HAN	P
49	Alan	10/22/2020	SFS21QQH-01	VACANCY SCI	A	EES87-01	CONWAY	A
50	Alan	10/22/2020	PGS85-01	SCAROLA	P	HLS43U-01	DOOBAY	P
51	Alana	10/22/2020	MGS21-04	LUPO	P	SFS43-01	VARGAS	P
52	Alana	10/22/2020	SFS41-01	CAVER	P	SES21Q9-03	FEISER	P
53	Albaneris	10/22/2020	RZS22-01	NEWMAN	L	ZJCOMSCI-01	HAN	P
54	Albert	10/22/2020	SLS21QQL-01	BRAVSTEIN	MISSING	PQS85QV-02	MEDITZ	P
55	Albert	10/22/2020	HUS21Q34-01	LOVE PERSAUD C	P	PPS85-02	GERARD	P
56	Alberto	10/22/2020	EES83QDX-01	LEVY JACKSON	L	SFS43-01	KARMODY	P
57	Aleesa	10/22/2020	SHS21QQH-01	SANDERS	P	EES87-01	CONWAY	P
58	Alejandra	10/22/2020	PPS85-01	KUSHNICK	A	EES87Q34-01	WHITE	A
59	Alejandro	10/22/2020	MGS21QQL-02	COHEN	P	ESS85Q12-01	PERSAUD C	P
60	Alessa	10/22/2020	EES85-01	MEDITZ	MISSING	PPS85-08	KUSHNICK	P
61	Alex	10/22/2020	SES21QQT-06	MEANEY PAUL	A	PPS85-08	KUSHNICK	A
62	Alex	10/22/2020	SHS61U-01	GATTA	L	FSS61-02	SHABANA	P
63	Alex	10/22/2020	RZS22-01	NEWMAN	L	SHS65T-02	ROSSIELLO	P
64	Alex	10/22/2020	HGS41QQR-01	AMALFITANO	MISSING	PQS85QB-02	RAMNARINE	A
65	Alex	10/22/2020	SLS21QQL-01	SHERIDAN	MISSING	EES83Q12-01	JAIRAM	A
66	Alex	10/22/2020	EES81Q9T-01	MEANEY PAUL	MISSING	SLS21Q9-02	SHARMA	P
67	Alex	10/22/2020	SLS21Q9-01	SHARMA	P	EES81Q9-09	MOHAN D	P
68	Alexa	10/22/2020	PGS85-08	SAMUELSEN	P	EES81Q9-09	MOHAN D	P
69	Alexander	10/22/2020	SHS21QQH-01	SANDERS	A	EES85QQT-01	CANZONERI COLIC	A
70	Alexander	10/22/2020	ZJPOPLIT-01	SINGH	A	PPS85-02	GERARD	A
71	Alexander	10/22/2020	SDS21QNM-01	WALLACE	MISSING	EES43QWA-02	VALDEZ	P
72	Alexander	10/22/2020	EES85-01	MARTI MUNOZ	P	SHS21QQH-02	SANDERS	A
73	Alexander	10/22/2020	PGS85-01	SCAROLA	P	ALS11U-01	SHERIDAN	P
74	Alexander	10/22/2020	PGS85-01	SCAROLA	P	EES43QWA-02	VALDEZ	P
75	Alexander	10/22/2020	MRS21-01	CHILLARA	P	FSS41QQL-01	BAEZ	P
76	Alexander	10/22/2020	SLS21Q9-01	SHARMA	P	MES41Q9-01	MAKSIMOVIC	P
77	Alexander	10/22/2020	PGS85-08	SAMUELSEN	P	EES81Q9T-02	GARRETSON ALDEN	P
78	Alexandra	10/22/2020	PQS85QF-01	AMALFITANO	P	EES43QWA-02	VALDEZ	P
79	Alexandra	10/22/2020	SES21Q9-01	FEISER	P	PPS85-02	GERARD	P
80	Alexel	10/22/2020	MGS21QQT-06	RAMOO MORANCY	P	ZJPOPLIT-10	VARGAS RODRIGUEZ	P
81	Alexia	10/22/2020	PQS85QF-01	AMALFITANO	P	SHS65T-02	ROSSIELLO	P
82	Alexian	10/22/2020	RZS22-01	NEWMAN	P	PPS85-08	KUSHNICK	P
83	Alexis	10/22/2020	PQS85QV-01	MEDITZ	A	EES85X-02	WOLF	P
84	Aliah	10/22/2020	PQS85QF-01	AMALFITANO	P	SFS43-01	VARGAS RIVERA	P
85	Alicia	10/22/2020	SLS21Q9-01	SHARMA	P	EES81Q9T-02	GARRETSON ALDEN	P
86	Alima	10/22/2020	KPS61T-01	JOSEPH	P	FSS61-02	SHABANA	P
87	Alinta	10/22/2020	PQS85QB-01	SHER	A	SHS21QQH-02	SANDERS	A
88	Alishba	10/22/2020	SLS21QQL-01	WALLACE	MISSING	EES41QWA-02	MALINAUSKAS	A
89	Alishba	10/22/2020	AYS21-02	SHERIDAN	P	EES83QQX-01	CHEESEBORO	P
90	Aliyah	10/22/2020	EES87X-01	GARRETSON	A	PQS85QB-02	RAMNARINE	A
91	Aljahron	10/22/2020	SES21Q9-01	FEISER	P	MES41Q9-01	MAKSIMOVIC	P
92	Altaaf	10/22/2020	MGS21QQT-06	RAMOO MORANCY	P	EES85QQT-01	CANZONERI COLIC	P
93	Alyssa	10/22/2020	PPS85-01	KUSHNICK	P	EES83QQX-01	CHEESEBORO	P
94	Alyssa	10/22/2020	FSS63-04	TAVERAS	P	SCS21U-01	PEREIRA	P
95	Amaesh	10/22/2020	HGS43QQX-01	ROBERTSON	A	PPS85-02	GERARD	A
96	Amanda	10/22/2020	EES85-01	WALLACE	L	ALS11U-01	LEVY JACKSON	P
97	Amanda	10/22/2020	PPS85-01	KUSHNICK	P	HGS43QDX-01	SOTIRYADIS DEVEAU	P
98	Amandeep	10/22/2020	MRS11QBT-01	CHEN LALL	A	ESS85Q12-01	PERSAUD C	A
99	Amara	10/22/2020		FISHER	MISSING	MRS21-02	PERSAUD L	A
100	Amara	10/22/2020	SES21Q9-01	FEISER	P	ZJPOPLIT-02	WALLACE	P
101	Amarias	10/22/2020	MRS11QBT-01	CHEN LALL	A	EES87Q34-01	WHITE	A
102	Amarnauth	10/22/2020	HGS41QQR-01	MOHAN D	MISSING	AHS21-02	ALFARO	A
103	Amaya	10/22/2020	SES21-01	BRAVSTEIN	A	PPS85-08	KUSHNICK	A
104	Amber	10/22/2020	EES83QDX-01	LEVY JACKSON	A	HGS43QDX-01	SOTIRYADIS DEVEAU	A
105	Ameera	10/22/2020	PPS85-01	KUSHNICK	P	HVS11QQT-01	MADIGAN HUSSAIN	P
106	Amel	10/22/2020	PHS11-01	FOUNTOULIS	L	SHS65T-02	ROSSIELLO	P
107	Amelia	10/22/2020	EES87X-01	GARRETSON	L	HVS11QQT-01	MADIGAN HUSSAIN	P
108	Amelia	10/22/2020	PQS85QB-01	SHER	P	ZJPOPLIT-10	VARGAS RODRIGUEZ	P
109	Amelia	10/22/2020	HGS43QQX-01	ROBERTSON	P	SFS43-01	KARMODY	P
110	Amina	10/22/2020	PQS85QB-01	REYES	P	EES85QQT-01	CANZONERI COLIC	P
111	Amir	10/22/2020	FSS61-01	SHABANA	P	KPS61T-02	JOSEPH	P
112	Amirah	10/22/2020	HGS41Q9T-01	MOTTOLA CAMACHO	P	SES21Q9-03	FEISER	P
113	Amisha	10/22/2020	MRS21-01	CHILLARA	A	HVS11QQT-01	MADIGAN HUSSAIN	P
114	Amit	10/22/2020	SES21-01	BRAVSTEIN	A	EES87-01	CONWAY	A
115	Amit	10/22/2020	SDS21QNM-01	FISHER	P	SFS43-01	KARMODY	P
116	Ammitoje	10/22/2020	MGS21QQL-02	COHEN	A	EES43QWA-02	VALDEZ	A
117	Amritpal	10/22/2020	MGS21QQL-02	NEWMAN	P	EES43QWA-02	VALDEZ	A
118	Amy	10/22/2020	EES81Q9-01	MOHAN D	L	MES41Q9-01	MAKSIMOVIC	A
119	Amy	10/22/2020	SHS21QQH-01	SANDERS	P	PQS85QV-02	MEDITZ	P
120	Anahi	10/22/2020	SDS21QNM-01	FISHER	A	PGS85-02	SAMUELSEN	P
121	Anahis	10/22/2020	HVS11QQT-02	MADIGAN COSMA	P	SHS65T-02	ROSSIELLO	P
122	Anais	10/22/2020	MES41Q9-10	MOHAN S	A	MES42Q9-10	MOHAN S	A
123	Anderson	10/22/2020	EES81Q12-01	HASSAN	P	HGS41Q12-01	BANGAREE CHIARAPPA	P
124	Andre	10/22/2020	SES21Q9-01	FEISER	P	ZJPOPLIT-02	WALLACE	P
125	Andrea	10/22/2020	PQS85QF-01	AMALFITANO	A	ZJCOMSCI-01	HAN	A
126	Andrea	10/22/2020	SHS61U-01	GATTA	A	SES21QQT-01	SULTAN PAK	A
127	Andrea	10/22/2020	PQS85QB-01	FEISER	P	SLS21QQL-03	GARRETSON ALDEN	MISSING
128	Andrea	10/22/2020	SES21-01	BRAVSTEIN	P	MGS21QQT-01	RAMOO MORANCY	P
129	Andres	10/22/2020	SLS21QQL-01	SHARMA	MISSING	EES41QWA-02	MALINAUSKAS	P
130	Andres	10/22/2020	SLS21Q9-01	FOUNTOULIS	P	PPS85-02	GERARD	A
131	Andrew	10/22/2020	MGS21QQT-06	RAMOO MORANCY	A	PGS85-02	SAMUELSEN	A
132	Andrew	10/22/2020	HUS21-08	MEIGHAN	A	EES85QQT-01	CANZONERI COLIC	P
133	Andrew	10/22/2020	AYS21-02	SHERIDAN	P	MGS21QQT-01	RAMOO MORANCY	P
134	Andrew	10/22/2020	EES87X-01	GARRETSON	P	SHS65T-02	ROSSIELLO	P
135	Andrew	10/22/2020	EES81Q9T-01	SOLOMON GIBBONS	P	PGS85-02	SAMUELSEN	P
136	Andy	10/22/2020	MRS21-01	CHILLARA	A	HUS21-04	LOVE	A
137	Andy	10/22/2020	HGS43QQX-01	ROBERTSON	P	PGS85-02	SAMUELSEN	P
138	Aneeqa	10/22/2020	SLS21QQL-01	SHER	MISSING	EES81Q9-09	MOHAN D	P
139	Aneury	10/22/2020	MGS21QQF-77	REYES	P	EES83Q12-01	JAIRAM	P
140	Angel	10/22/2020	MGS21QQT-06	RAMOO MORANCY	A	PQS85QB-02	RAMNARINE	A
141	Angel	10/22/2020	APS21-01	MARTI MUNOZ	A	MRS11QBH-01	GENAO	P
142	Angel	10/22/2020	PGS85-01	SCAROLA	P	EES87Q34-01	WHITE	P
143	Angel	10/22/2020	SHS21QQH-01	SANDERS	P	EES85QQT-01	CANZONERI COLIC	P
144	Angel	10/22/2020	SLS21Q9-01	SHARMA	P	MES41Q9-01	MAKSIMOVIC	P
145	Angel	10/22/2020	SHS61U-01	GATTA	P	PPS85-08	KUSHNICK	P
146	Angel	10/22/2020	MGS21-04	LUPO	P	EES41QWA-02	MALINAUSKAS	P
147	Angel Miguel	10/22/2020	MGS21QQL-02	COHEN	P	ZJCOMSCI-01	LEVY JACKSON	P
148	Angela	10/22/2020	MRS11QBT-01	SHER	P	EES87Q34-01	WHITE	A
149	Angelena	10/22/2020	FSS61-01	SHABANA	A	SES21-02	BRAVSTEIN	A
150	Angelic	10/22/2020	FSS61-01	SHABANA	P	SCS21U-01	PEREIRA	P
151	Angelica	10/22/2020	EES81Q9-01	MOHAN D	A	MES41Q9-01	MAKSIMOVIC	A
152	Angelica	10/22/2020	PQS85QF-01	AMALFITANO	P	MGS21QQH-09	SANCHEZ	P
153	Angelica	10/22/2020	SHS61U-01	GATTA	P	MRS21H-01	CHEN	P
154	Angelin	10/22/2020	PQS85QV-01	MEDITZ	P	MGS21QQH-09	SANCHEZ	P
155	Angelina	10/22/2020	HGS41Q9T-01	MOTTOLA CAMACHO	A	MES41Q9-01	MAKSIMOVIC	P
156	Angelina	10/22/2020	SFS41-01	CAVER	P	MES41Q9-01	MAKSIMOVIC	P
157	Angelina	10/22/2020	EES81Q9T-01	SOLOMON GIBBONS	P	SLS21Q9-02	SHARMA	P
158	Angelis	10/22/2020	HGS41Q9T-01	MOTTOLA CAMACHO	A	EES81Q9T-02	GARRETSON ALDEN	A
159	Angely	10/22/2020	AYS21-02	SHERIDAN	P	MGS21QQT-01	RAMOO MORANCY	P
160	Angie	10/22/2020	MGS21QQF-77	ARRIOLA	P	SLS21QQL-03	VALDEZ	MISSING
161	Angie	10/22/2020	MGS21QQF-77	REYES	P	ESS85Q12-01	PERSAUD C	P
162	Anisah	10/22/2020	EES87X-01	GARRETSON	P	PQS85QB-02	RAMNARINE	P
163	Anisha	10/22/2020	EES81Q9-01	MOHAN D	P	PQS85QB-02	SHABANA	P
10.22.20

 

[Fluff]

What do you want to do with the values from C & D if E is missing?