You can put all your data in a column to retain the dropdown or you can validate
the cell using a custom formula:

With A1 the cell getting Data|Validation and the numbers in A15:D17, I used this
formula:
=COUNTIF($A$15:$D$17,A1)>0

Native wrote:
>
> Hello:
>
> Have searched for this but figure either I'm calling this the wrong
> thing or is a limitation.
>
> I have a range of cells I would like the data validation to choose
> from. For example:
>
> 1 4 9 12
> 56 3 24 1
> 8 18 49 3
>
> I'd like all of these #'s to be in my list to select from; however, all
> I can get the list to accept is just one column.
>
> Any advice?

--

Dave Peterson