contestada

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.

Respuesta :

Dibny
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)

The creation of the formula by using the vlookup function is =VLOOKUP(D5,G4:H7,2)

What is vlook function?

VLOOKUP means that Vertical Lookup'. It is a function that should be used in excel for searching the specific value in the column or the table array. This is to be used for returning the value from the distinction column in the similar row.

Therefore, The creation of the formula by using the vlookup function is =VLOOKUP(D5,G4:H7,2)

Learn more about program here: https://brainly.com/question/13906743

Otras preguntas