I set up this spreadsheet to take attendance over Zoom each Am with my students. Students fill out a Google Form to check in. Their data goes into a connected spreadsheet, which in turn goes into a sheet displaying student attendance.  

**Prior to any student data being entered**, the cells in rows 3-6 have an error message:

> 
> Error: Query completed with an empty output.
> 
> 
> 

Then when a student name populates one of these cells, the following message appears:

> 
> Error: Array result was not expanded because it would overwrite data in G3.
> 
> 
> 

**What I want to happen is for a student name to be displayed (complete with conditional formatting).**

Here's a link to the spreadsheet: <https://docs.google.com/spreadsheets/d/1DpERPaq8yIwDKHkp4T463D6GL5WHAVwHAVYqGmHNJxQ/edit?usp=sharing>