hmm.. am sorry, but am really not able to understand your objectives fully. Are you trying to make sure people don't mis-spell the hotel names when they enter the data?? If yes, you could create a named range with the list of available hotels and put that into the validations of the cells where they'll be entering the hotel names.

If no, I'll need to understand your needs a little more..