contestada

Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.

Respuesta :

Answer:

The vlookup formula is given below

(Vlookup,I5,A17:G20,9,1)

Please mark brainliest

Explanation:

In cell I6 write this formula (=Vlookup,I5,A17:G20,9,1)

While writing the formula press tab to select vlookup then select the value you want to look then add a comma then select the range of the data you want to look in then add comma then write the number of the column number you want the data from then add comma then there will be a choice of approximate or exact, select 1 or 2 accordingly and press enter.

Otras preguntas