Question

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

Answer 1

To complete the summary section with VLOOKUP in Excel, the formula to be entered in cell J20 is '=VLOOKUP($J$19, $B$10:$J$15, 2, FALSE)', which will search for the reservoir number in cell J19 within the absolute range B10:J15 and return the value from the 2nd column.

Step-by-step explanation:

To complete the summary section using lookup functions in Microsoft Excel, you would need to create a formula with VLOOKUP to display the measured precipitation for a selected reservoir. Specifically, in cell J20, the formula should lookup the value in cell J19 within the range B10:J15 and return the corresponding value from the 2nd column of that range. Using absolute references, the formula in cell J20 would look like this:

=VLOOKUP($J$19, $B$10:$J$15, 2, FALSE)

This formula includes the absolute references (signified by the dollar signs) to both the lookup value and the range, ensuring they do not change if the formula is copied to elsewhere in the worksheet. The number '2' indicates that the function should return the value from the second column of the specified range, and 'FALSE' specifies that the lookup should find an exact match for the lookup value.