If you want to switch up the C and F, you need one INDEX with a MATCH for the row and a MATCH for the column, like this:
=INDEX($B$2:$G$14,MATCH($I2,$A$2:$A$14,0),MATCH(J$1,$B$1:$G$1,0))

If you don't need to do a match on the date, then simply remove that part of the formula:
=INDEX($B$2:$G$14,,MATCH(J$1,$B$1:$G$1,0))
Or if you want to use HLOOKUP, then like this:
=HLOOKUP(J$1,$B$1:$G$14,ROW(),TRUE)
