Hi all I have created a drop down list containing "North", "South", "East" & "West" in B2:B6 from the list in column E using range "Area"
In C2:C6 I would like to create drop down lists depending upon the selections in C2:C6
The lists I would like to use are in columns F:I
I have tried using an IF formula in Data Validation but it didn't like that.
I haven't tried HLOOKUP or VLOOKUP
Any help would be appreciated.
Set up 4 further named ranges (North, South, etc,) and use
=INDIRECT(B2) as the DV in column C
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The best explanation for dependent data validation lists.
http://www.contextures.com/xlDataVal02.html
Create named ranges called "North_ListT","South_List" etc
for C2
Data Validation
=List
Refrers t0: =INDIRECT(B2 & "_LIST")
That was so quick
Thank you Glenn Kennedy
You're a genius
Thank you to everyone for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks