Excel Lookup
 

I am trying to build a form. I have a cell (A1) in which data is pulled from
a list. I have another Cell (A2) that looks to see what data is pulled from
the list and then uses that to pull from another list and enter in cell A2

i.e. Cell A1 chooses between a list of colors: red, yellow, green, blue
if Cell A1 is red I need cell A2 to pull from a list of numbers; 1, 2, 3,
if Cell A2 is yellow I need cell A2 to pull from another list of numbers:
5, 6, 7,

ad infinitum.

Is this doable?

Excel Lookup
 

See if this is what you had in mind:

http://contextures.com/xlDataVal02.html

--
Biff
Microsoft Excel MVP


"fluffy" wrote in message
...
I am trying to build a form. I have a cell (A1) in which data is pulled
from
a list. I have another Cell (A2) that looks to see what data is pulled
from
the list and then uses that to pull from another list and enter in cell A2

i.e. Cell A1 chooses between a list of colors: red, yellow, green, blue
if Cell A1 is red I need cell A2 to pull from a list of numbers; 1, 2,
3,
if Cell A2 is yellow I need cell A2 to pull from another list of numbers:
5, 6, 7,

ad infinitum.

Is this doable?