Create lookup functions to complete the summary section. In cell J$20,$ create a formula using the VLOOKUP function to display the measured precipitation for the selected reservoir. Lookup the reservoir number $($cell J$19)$ in the range $B10$:$J15,$ and return the value in the $2$ nd column number. Use absolute references for cell $J19$ and the range B$10$:$]15.$

Copy only the formula from cell $J20$ to the range $J21$:$J25,$ and then edit the formula in cell $321$ to return the value in the $3$ rd column, the formula in cell $J22$ to return the value in the $4$ th column, the formula in cell $J23$ to return the value in the $5$ th column, the formula in cell $J24$ to return the value in the $8$ th column, and the formula in cell $J25$ to return the value in the $9$ th column.