Matching Date to Values

[derivative_x]

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!

[TMS]

You could use:

Please Login or Register  to view this content.

for the High, Low and Median although, in every case, it will report the first value that matches ... and there are a few for the Median.

The Average won't necessarily match anything unless you round the value calculated. And the Range won't match anything.

Regards, TMS