It sounds like you could use dependent data validation lists. There are
instructions he

http://www.contextures.com/xlDataVal02.html

amit wrote:
Debra,

Thanks a lot for your reply.

I tried that but it doesn't help for list of values.

More specifically:

I have 12 columns, each containing a list of 100 values (1 value in a
cell).

Based on the value of a cell, different from the cells mentioned
above, in range of 1 to 12 one of the list is to be selected in Drop
down list (using Data Validation ---List ----Formula).

The above mentioned field at the end of path allows only 8
IF-THEN-ELSE type statements.

I tried using Index, Match, address functions etc. but I am not able
to get the solution.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html