Excel Lookup

[fluffy]

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?

 

[T. Valko]

See if this is what you had in mind:

http://contextures.com/xlDataVal02.html