Excel Lookup

F

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top