I have my data sheet where I have 4 columns, C-date, D-physcial, E-emotional,
F-physical....on a different sheet, I need a formula to find the peak value
and corresponding date...

I have used the large formula to find the 3 highest values and then tried to
use the Vlookup formula to find this corresponding date. I don't know if
this is the right way around it, but it's all i've been able to come up with

at the moment my formula looks like this: =VLOOKUP("=large('Data
(2)'!$C$9:$C$31,1)",'Data (2)'!$C$9:$D$31,2,FALSE)

But i keep getting a N/A value...can anyone please help my ASAP...I've never
used formulas this difficult before.