Sorting data from a drop-down list doesn't work

[PacoPolo]

I´m trying to use this formula =ordenar(INDIRECTO("Stock[Descripción de producto]"))

From Data Validation, drop-down list... but it doesn´t work

why?

[#2 · Accepted solution]

@PacoPolo That's just the way it is. Data Validation list must be a (named) range (direct or indirect) or a dynamic array. You can't use a formula that creates a dynamic array.

If you can't (or don't want to) sort the column in the Stock table, create a sorted dynamic array outside the table (perhaps is in separate sheet) and refer to the first cell of the array followed by a #.

Let's say you enter the formula that you now have in the DV list box in cell A1 on the sheet 'DV_lists', then enter =DV_lists!$A$1# as the source for the list.

[#3]

@Riny_van_Eekelen 

Hi, Riny

Thanks a lot for your explanation and recommendation.