Question

In cell e5, create a formula using the vlookup function to determine the dog type for teen anna morante based on the program code listed in cell d5. use range g4:h7 as the lookup table and the dog type listed in column 2 of the lookup table. do not enter a value for the optional range_lookup argument.

Answer 1

Answer: =vlookup(d5, g4:h7 2

Explanation:

Answer 2

Hello! For the arguments needed in using the VLOOKUP function, we need the value you want to lookup, the range of the table, and the column where the return value is located. In your problem you have already given the range and the column, but it is unclear what you want to lookup. For the purposes of this answer I'll assume you want to find the value in cell D5. You can just change this value to whatever you need to find.

Putting this into syntax we'll get:
=VLOOKUP(D5,G4:H7,2)