Hi all
I am trying to set the data validation on a cell based on another cell value
So basically if the User enters say CAN in cell A2, cell B2 should use "listCAN" range as the data validation list
and if i enter US in A2, B2 should use "listUS" as the data validation list ?
any help is greatly appreciated. Thanks
Last edited by manny_cb; 07-14-2009 at 12:32 PM.
Your 2nd validation list would use an INDIRECT function as source:
=INDIRECT("list"&A2)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
That wont work
I can enter either U001 or CA01 as my option in A2.
But when i do to name my dependent ranges as U001.. It says name is not valid :S
so the problem still remains
if i enter U001 in A2, I want B2 to use LISTUS for validation
if i enter CA01 in A2, I want B2 to use LISTCAN for Validation
please help. Thanks
Try allow
list
source
=IF($A$2="U001",listus,listcan)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Given this is completely different to your original post it's not surprising the prior suggestion didn't work... do you mean U001 or US01 (I ask given CA01)if i enter U001 in A2, I want B2 to use LISTUS for validation
if i enter CA01 in A2, I want B2 to use LISTCAN for Validation
If you have lots of sub lists it makes a lot more sense to keep your named range naming convention such that it reflects the choices in the original list.
hear,hear! requirements do seem to have changed somewhat!
That would do the trick .
Thanks a lot for your quick help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks