Home /
Expert Answers /
Other /
6-create-lookup-functions-to-complete-the-summary-section-incell-i6-create-a-formula-using-the-vlook
(Answered): 6. Create lookup functions to complete the summary section. Incell I6, create a formula using the VL ...
6. Create lookup functions to complete the summary section. Incell I6, create a formula using the VLOOKUP function to display thenumber of hours worked in the selected week. Look up the weeknumber in cell I5 in the range A17:G20, and return the value in the2nd column. Use absolute references for cell I5 and the rangeA17:G20.
Home Insert Draw Page Layout Formulas Data Review View Acrobat Tell me fx Q le Define Name e, Trace Precedents Trace Dependents Error FRemove Arrows Formulas Checking x x Insert Function Date & Lookup & Math & Time Reference Trig More Functions Create from Selection Show Calculator Options 16 A E F H K AutoSum Recently Financial Logical Text Used x fx B ? D Reporting Period Hours Name Period start 2/1/21 Period end 2/26/21 Date completed 7/3/20 Timesheet due 2 3/5/21 Balances Period Start Period End 1 Summary Week Worked Holiday Vacation sick Comp Total Weeka Mion Hours Worked Wed 7.5 Ful Tue 8.5 7.5 8 56.00 24.00 6.50 86.50 10 2 0 8 7 9 8 0 9 7.5 8.5 11 8.5 8 12 13 14 15 Hours Used Other Hours Wied Hours worked per day Week Hours Worked Total Hours For Week 16 Holiday Vacation Sick Comp 1 28.00 10.00 200 Maximum 40.00 18 Minimum 40.00 40.00 19 32.00 8.00 40.00 44.00 44.00 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
