This is the offset example option:
Where ListStart is the named range for the first entry.
In your list validation box, use any range name, i.e. =myrange.
Create the myrange range, (in the Insert Name Define dialog, enter the offset formula as the range for myrange.