data validation

[ns21]

I have made data validation from list for a cell A1. What i want to know is how to put drop down validation list for cell B2 based on input value in A1

 

[Dougie1]

I have done this before and used the methodology in cell B1 of through Data Validation allowing a List and setting the Data Validation Source as =INDIRECT(“L”&A1) where L refers to my possible selection of lists for column B (these lists are called L1, L2, L3, L4 etc and have been defined as such). This then generates a list of options in the cell B1 dropdown list dependent on what the text is in A1. This A1 value has also been selected from a list - where the options are 1,2,3 or 4.

Hope this helps,

D

 

[ns21]

im not sure what r trying to say.......

just to add a little more to the query

i have made data validation in cell A1
- the validation range is data in cells F4 : F10

now what im looking for in cell B1
- validating the cell with data range say cell G4 : G5 or H4 : H10 based on value input in cell A1

 

[ns21]

thanx dougie1.....ur solution has worked well for me