No you are right, if you have spaces in your named range (because you built them in just in case the list grows) then naturally anything you enter in the validation cell will be correct!, you should create a dynamic named range, go to Debra Dalgliesh' site here http://www.contextures.com/xlNames01.html and create a dynamic named range, this range will then expand and contract depending on how many cells have data.