Hi,
Can somebody help please..
I need my drop down list (range) to be dynamic based on the content of a reference cell.
As I have tried, you can use an IF statement on DATA validation list but is only limited to 7 IFs.
Please see attached.
Thankx so much,
juls
Last edited by juliustp; 06-09-2016 at 01:27 PM.
Hello welcome to the forum.
I created a dynamic named range "Drop_down_List", with the following formula:
Formula:
Please Login or Register to view this content.
I then used this named range for the Data Validation list. It's seems to work OK on your sample file. Test it out to see if it works out for you.
DBY
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks