Thread: Drop down box list based on response to another drop down box
View Single Post
 
Old 04-12-2018, 07:42 AM
Phideaux Phideaux is offline Windows 7 32bit Office 2003
Novice
  
Join Date: Apr 2018
Posts: 8
Phideaux is on a distinguished road
Default
Quote:
Originally Posted by p45cal View Post
In the attached, is data validation in column B which refers to a dynamic named range called drpdwn2 as the list.
The formula was added to the named ranges while the active cell was in row 3:
Code:
=OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0,,COUNTA(OFFSET('Front Sheet'!$B$19:$M$19,MATCH('Front Sheet'!$A3,'Front Sheet'!$A$20:$A$34,0),0)))
It is dynamic both in width and vertical position.
I really like this approach simply because I am familiar with it! The question that I would like to ask is, can this approach draw values from another worksheet within the workbook? This would keep the front page "clean", as in no other tabular data being seen.
Reply With Quote