Vlookup Headache
 

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.

Hi!

You just have some uneeded "junk" in your formula. Try this:

=VLOOKUP(LARGE('Data (2)'!$C$9:$C$31,1),'Data (2)'!$C$9:$D$31,2,FALSE)

Biff

"Stressed Out!!" <Stressed wrote in message
...
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.