Full questions is to 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 entered =VLOOKUP(I5,A17:G20,2) formula but it is not working. What is the meaning of use absolute reference?
Reading books is a great way to learn. Here are some of the books we recommend.
You entered the correct formula but you missed to use the absolute reference. For that you need to enter
F4key or add$sign in front of the each letter of cell number. If you want to absolute referenceF4cell you should type it as$F$4.So the required answer would be
=VLOOKUP($I$5,$A$17:$G$20,2).If you absolute reference the cell then it will remain constant if you copied the formula to other cells. Google it if you want to know more about absolute vs relative reference.