Question: 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

"Create lookup functions to complete the summary section. In cell I6,

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

I have no idea how to make the function and what cell I'm putting it in.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Create lookup functions to complete the summary section. In cell I 6 , create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number...

Timesheet due 3/5/2005 Reporting Period Hours Name Period start 2/1/2021 Perledend 2207001 Date completed 114/2019 Balances Period Start Period End Summary Web Worked Holiday vacations Hours Worked ....

Create lookup functions to complete the summary section. In cell 1 6 , create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number...

Create lookup functions to complete the summary section. In cell J 2 0 , create a formula using the VLOOKUP function to display the measured precipitation for the selected reservoir. Lookup the...

Server Document The file is read - only. To modify the file, open the latest version or s . . . rspectives Excel 3 6 5 / 2 0 2 1 | Module 3 : End of Module Project 2 1 2 . Create lookup functions to...

Create lookup functions to complete the summary section. In cell create a formula using the V LOOKUP function to display the measured precipitation for the selected reservoir. Lookup the reservoir...

Create look up functions to complete the summary section and see I six creative formula using the V look up function to display the number of hours work in the selected week look up the week number...

Need help with Excel. 1. Jack Roscoe started running a sports blog two years ago, and since then, it has provided a second income for him and his family. Jack is reviewing the recent articles written...

The city of Honu Point wants to fast-track mixed-use development projects that use loans for funding. Add a column to the ProposedProjects table, and determine which projects meet the criteria as...

PROJECT STEPS Jack Roscoe started running a sports blog two years ago, and since then, it has provided a second income for him and his family. Jack is reviewing the recent articles written for the...

Describe the effect on a call options price that results from an increase in each of the following factors: (1) Stock price, (2) Strike price, (3) Time to expiration, (4) Risk-free rate, and (5)...

The following graph represents the mass of bacteria (in micrograms) in a petri dish in a laboratory experiment in terms of the number of hours since the experiment began. 281 24 20 (5.2, 15.65) 16...

What are the rights of Jill's estate and what are the liabilities of the Justin and Fred?

Which of the following systems is the least scalable with respect to its number of processors? A. Cache-coherent NUMA systems B. Symmetric multiprocessors C Noncache-coherent NUMA systems D None