How to set up data validation across the table

Users questions: I put the data definition name, and then set the validity, but only a drop-down menu, for the wrong data will not prompt an error, please help him! Details, please read attachments, and pleasant way to work, suggesting that the table can not set the effective cross- of
Experts answer:, "name" to the following on it. = Data! $ A $ 1: $ A $ 48 re-enter to see the results. See accessories. Accessories :2009-11-7Book1. Xls
  • This information provided by the users.Thanks!