Hello - I've read thru a few postings on dependent data validations but can't quite seem to get mine working properly. I have attached the spreadsheet with notes on how I want the two data validations to operate. On the 'Data' tab I have two data setup scenarios that I've attempted to use but can't seem to get it working with either. Please help if you can. Thanks soooo muchCampaign x Month.xlsx
pretty sure you can do it with some offset formula in named ranges but i cant think of it at the moment
so went with indirect/Code/match combination
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This hundingaling! That worked great, appreciate the help!
hi MeCe. you could follow the guide to this link:
http://www.excelforum.com/excel-tips...t-problem.html
basically, you can do step 2 & 5 and skip step 3 since your months are a fixed number. so
- Name D21 AnchorCell
- Named Range for Campaign:
=OFFSET(AnchorCell, 1, MATCH(Dashboard!$C$3,Month, 0)-1, COUNTA(OFFSET(AnchorCell, , MATCH(Dashboard!$C$3, Month, 0)-1, 50, 1))-1, 1)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Great reference, benishiryo! Bookmarked for future use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks