INDIRECT function question

J

Joe

I am using XL 2002 on an XP pro box.

I have an applciation that extensively uses Validation Lists. Here is what
I would like to do:

In cell A1, I have the Validation list set to v_A1_List.
In cell A2, I have a Validation list set to either v_A2_List1 or v_A2_List2,
depending on the value chosen in cell A1. I'm pretty sure that this is
possible using the INDIRECT worksheet function. I'm just not sure how to
implement it.

BTW, I also need to use worksheet fundtions to do this. Right now, VBA is
not a via alternative.

Any ideas would be greatly appreciated.

TIA,
 

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

Similar Threads

Excel - Wich Function should I use? 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Help with Address(), Indirect(), Offset 2
Using 'indirect' function with full network path 0
INDIRECT Function 9
Search tab using indirect for number of times in a range 3
Formula in dropdown list 2
Return a value if a range of cells contain text 2

Top