Matching Date to Values

**derivative_x** · 07-09-2012, 06:19 PM

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** · 07-09-2012, 06:30 PM

You could use:

Formula:



=INDEX(A:A,MATCH(I4,B:B,0))

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