Apply a named range to worksheet

[FryGirl]

I'm using a named range in the name manger to populate a dependent drop down box.

How can I apply that named range to the worksheet?

Instead of seeing all the values in the drop down box, I would like to see them in a column.

I know I can typically just apply a named range just like a formula, but in this case, the result of the named range spans multiple values.

 

[sheetspread]

=INDEX(namedrange,row(a1))

drag down


?

 

[FryGirl]

Thank you. That will work fine.