As shown above

Check B1?Data? Validity? Sequence? Source? =$F$1:$I$1?OK

Check C1?Data? Validity? Sequence? Source? =OFFSET($F$2:$F$9,,MATCH($B$1,$F$1:$I$1,0)-1)? OK

You can structure your data according? Modify the formula above.