VLOOKUP function finding MIN value or MIN(IF()) Function

[gateway123]

I want to fetch the least value for 1 and 2, but I also want to fetch year associate with that minimum value.

1 2000 0.01 1
1 2001 0.00 2
1 2002 0.04
1 2003 0.09
1 2004 0.04
1 2005 0.06
2 2000 2.01
2 2001 3.00
2 2002 7.04
2 2003 1.09
2 2004 2.04
2 2005 0.06



Results should look like

1 2001 0.00
2 2005 0.06


gsistek suggested this function it gives only the minimum value but I also want the year associated with this value
=MIN(IF(A1:A11=D1,C1:C11,9.99E307))

 

[texasalynn]

duplicate
http://www.mrexcel.com/forum/showth...ction-finding-MIN-value&p=3212640#post3212640

 

[pplstuff]

Say that formula is in E1.

F2: =index(b$1:b$12,match(E1,c$1:c$12,0))

Note, if the max appears more than once this will result in an error.

 

[VoG]

Continuation of http://www.mrexcel.com/forum/showth...ction-finding-MIN-value&p=3212640#post3212640

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).