Data Validation Ignore Blanks not working

[Stan]

i am using =INDIRECT(A1) in my data validation. "A1" is a Named Range on
another sheet (it is also the name of sheet, if that is significant). i do
this so that the contents of 'col2' corresponds to some value chosen in
'col1'. i have the named ranges set up correctly (i think), but there are a
ton of blank lines in my resulting list (the Named Range does indeed include
blank lines). i assumed that "Ignore Blanks" would take care of extraneous
blank values, but they still exist. am i doing something wrong?

 

[Debra Dalgleish]

If 'Ignore Blanks' is checked, you won't get an error message if a
referenced cell, or the cell with data validation, is blank.

However, it won't eliminate blanks from the source range for a dropdown
list.