I have several columns with time values. With a Data Validation, I display a list that takes the values from a hidden column with a large range of time values. Depending on the value of another field, I can take portions of the range to display the value list. That works perfectly:

Source:
=IF($b$6=$X$8;$X$13:$X$171;$X$193:$X$521)

for a certain value in B6, it takes a certain portion of range X

Now, in the rows of column C I want a time list with values starting from 10 minutes later than column B.
For this, I can perfectly trace the position of B+10 minutes with the Match function. I also add +12 because the list starts at row 13:

=MATCH(B13+TIME(0;10;0);X13:X326;1)+12 => results in 24

As from there, I can perfectly define the range I want:

=”$X”& MATCH(B13+TIME(0;10;0);X13:X326;1)+12 & “$X100” => results in $X24$X100

Now, how do I apply this range into the Source for Data Validation list?
It lists the string as literal text, not as a range (see screenshot).

it applies the string as literal text, not as range