Data validity diagram of scheme 1
=$A$ 1:$C$ 1
Select the data validity reference map of seconds and use the offset function to locate the data.
=OFFSET($A$2:$A$ 10,0,MATCH(E 1,$A$ 1:$C$ 1,0)- 1)