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.

Question

1.      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

This is how a VLOOKUP is formatted:

VLOOKUP(Lookup cell, range, column to return)

VLOOKUP(J19,B19:J15,2)

For absolute references, you would use $ for this. I think it makes sense to use those for the table range, but not sure why it would be on the lookup value. But here is what it would look like with absolute references added.

VLOOKUP($J$19,$B$19:$J$15,2)