SPREADSHEET TERMS

Use the VLOOKUP() function to look up each person's age in the range named rates (B4:D7), and return the basic annual fees (column 2). Use the IF() function and VLOOKUP() to look up the cost of a car park space only if the person wants one (i.e. there is a Y in the Use of Car Park? column), else return a … ................
................