Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
VLOOKUP not working | Excel Worksheet Functions |