The formulas in cells A$9$:A$23$ reference a named range that doesn't exist. There is more than one correct way to fix this problem using the cell range A$2$:H$15$on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead.