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.

This is on simnet excel fix it $3-6.$