Excel Help1.xlsx

I am not sure which function I am supposed to be using.

What I did was create a table that calculated some basic statistics, then after I calculated the statistics, I wanted to use a function that would match the date to the value. So far I have tried VLOOKUP, HLOOKUP, and MATCH with no success on my end, but I'm pretty sure I'm doing something really silly wrong.

What functions should I be using for each stat (highlighted in yellow)?

Thanks!