I'm trying to create a dynamic dropdown that references a cell which contains the name of my dynamic ranges. For the example the named range is called NAMED. If I type =NAMED into a cell it populates my list, or if I go into data validation-list =NAMED I get a list. What I'm trying to do in data validation is =Indirect(b4) where b4 would contain NAMED but this is giving me an error and the dropdown is not populating.
My dynamic ranges are made in the name manager using =OFFSET(sheet1!k3:K16,0,0,counta(k3:k16)) and as previously mentioned if I type =NAMED anywhere I get the appropriate list. Thank you in advance.
Bookmarks