3G
Member
Hi there-
I have some data validation columns (3 total) set up, with the third column dependant on the first two. However, that third column is a dynamic list as a result of the first two selections. The dynamic list is populated by the following formula:
=IFERROR(INDEX(DatabaseName,SMALL(IF(($D$14:$D$71=$J$19)*($C$14:$C$71=$I$19),ROW($D$14:$D$71)-ROW($D$14)+1),ROWS($D$14:$D14))),"")
The Named Range I have for the DatabaseName is =OFFSET('CFG DBs'!$K$24,0,0,COUNTA('CFG DBs'!$K:$K),1)
Named range switches perfectly from the formula, it's just that some combinations of the previous 2 drop downs will create blanks from the extra rows that I copied the formula down (some combinations will have only 1 result, others more than one). What I'd like to do is have the drop down ONLY have those items that appear in the list..and not the blank placeholders for the copied down formulas (the IFERROR portion).
Thanks!
I have some data validation columns (3 total) set up, with the third column dependant on the first two. However, that third column is a dynamic list as a result of the first two selections. The dynamic list is populated by the following formula:
=IFERROR(INDEX(DatabaseName,SMALL(IF(($D$14:$D$71=$J$19)*($C$14:$C$71=$I$19),ROW($D$14:$D$71)-ROW($D$14)+1),ROWS($D$14:$D14))),"")
The Named Range I have for the DatabaseName is =OFFSET('CFG DBs'!$K$24,0,0,COUNTA('CFG DBs'!$K:$K),1)
Named range switches perfectly from the formula, it's just that some combinations of the previous 2 drop downs will create blanks from the extra rows that I copied the formula down (some combinations will have only 1 result, others more than one). What I'd like to do is have the drop down ONLY have those items that appear in the list..and not the blank placeholders for the copied down formulas (the IFERROR portion).
Thanks!