please help with step 8 to provide formula according to the requirements listed in cell D5 to copy down to cell D36 - thank you so much (so very appreciated)

Step Instructions The Reservation_Analysis sheet displays data regarding reservations made by customers during the week of September 4, 2022 through September 10, 2022. You must help the manager of CVRCC complete the Reservation_Analysis sheet. Enter an XLOOKUP function in cell D5 of the Reservation_Analysis sheet. The lookup function must find the Customer_ID (cell C5) in the Customer_Data sheet and return the Rewards_ID. (Note: N/A is displayed if the customer is not a rewards member.) If the Customer_ID is not found in the Customer_Data sheet, the following text should be displayed: Not Found. (Do not include the period.) Copy the formula in cell D5 down the column to cell D36. Catawba Valley Resort and Convention Center Reservations for the week of 9/4/20229/10/2022