Chapter 7 - Lookup Functions

” in the first column. (Note: The closest match parameter requires that the first column be sorted in ascending order.) For this exercise we want to know the number of required units and the cost per unit of two parts which may be contained in the Lookup Table. Begin by typing the following formula in cell B11: =vlookup(A11, A4:C7, 2, False) A11 ................
................