Chapter 7 - Lookup Functions

Put it all together in a formula with the VLookUp function: In Cell D23, key =VLOOKUP(cell address of your first food, cell range of foods list, column number for calories) For example: =VLOOKUP(A23,A1:L20,3) Before copying the formula to the remaining cells in Column B, make the cell range for the foods list (A1:L20) absolute. Check for accuracy. ................
................