Drop down list produces defined range list in an area

Question

I have a drop down list in E8 that has several item categories in it and below the drop down box I have a square B9 to H24. How can I with the Level 3 drop down selection show a defined named range (!P:P) in the box between b9 and h24

Answer 1

You could refer to named range dynamically like this:

=INDIRECT(E8)

---

To 'split' a column into a specified 'box area':

=TRANSPOSE(INDEX(VLOOKUP(SEQUENCE(ROUNDUP(COUNTA(P:P)/ROWS(B9:H24)),ROWS(B9:H24),1,1),{ROW(P:P),P:P},2,FALSE)))