Go to the Survey Results worksheet: in the Workshops column, display the text associated with answers to column Q$1$ by clicking cell I$6$ and inserting the XLOOKUP function to do an exact match lookup with the Q$1$ field as the lookup value, the survey$\_$lookup range $($on the Lookup Table worksheet$)$ as the lookup array, and the rating$\_$lookup range as the return array.

Repeat Step $3$ for the "Speakers" through the "Meals" fields using the values of the $"$Q$2"$ through $"$Q$4"$ fields. $($Hint: You can use AutoFill to quickly enter the formulas for the "Speakers" through the "Meals" fields.$)$

In the "School" column, display the type of school for each attendee $($Public$,$ Private, Online, or Tutor$)$ by clicking cell M$6$ and inserting the XLOOKUP function to do an exact match lookup of values in the Q$5$ field from the school$\_$lookup range $($on the Lookup Tables worksheet$)$ and returning values from the type$\_$lookup range.

$"$In the $""$Prior Conferences"" column, indicate the number of conferences previously attended $(0,1,2,$ and $3+)$ by clicking cell N$6,$ using the XLOOKUP to do an approximate match lookup of the values in the Q$6$ field using the conference$\_$lookup range as the lookup array $($on the Lookup Table worksheet$)$ and returning the value from the prior$\_$lookup range,Set the match$\_$mode value

to $-1."$