Name

The first argument to the VLOOKUP function is the asset’s age. The second argument is the location of the vlookup table (cells A14 to D14, using absolute references so that the formula can be correctly copied). The third argument is the row in which to find the answer. In this case, the row is given by the result of the MATCH function. ................
................