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