return min value in vlookup

[meweaver27]

Here is what I need: A formula to get me the minimun value from a vlookup. What would the formula be under "earliest run date"

Thanks in advance!


Production Schedule Example

Line part run-date
1 A 7/1/2007
1 B 7/2/2007
1 C 7/3/2007
1 D 7/4/2007

2 B 7/1/2007
2 D 7/2/2007
2 C 7/3/2007
2 A 7/4/2007

3 C 7/1/2007
3 B 7/2/2007
3 D 7/3/2007
3 A 7/4/2007


earliest run-date
A 7/1/2007
B 7/2/2007
C 7/3/2007
D 7/4/2007

[SteveG]

meweaver27,

Try this array formula,

=MIN(IF(B1:B14="A",C1:C14))

Commit with Ctrl+Shift+Enter. Should look like:

{=MIN(IF(B1:B14="A",C1:C14))}

Don't enter the {} manually.

HTH

Steve

[meweaver27]

thanks! I have several parts so if I want the earliest for several can i drag this formula down and reference the cell D2 rather than the actual part "A".

Say I want the 'early run-date' formula in E2

how can I make this work?
=MIN(IF($B$1:$B$14=D2,$C$1:$C$14))

arrays are something I have never done before and do not understand


parts early run-date
A 7/1/2007
B
C
D
E
F

[SteveG]

Yes you can. Your formula you posted will work so long as you commit with Ctrl+Shift+Enter rather than just enter. You can then drag the formula down for different lookup values.

=MIN(IF($B$1:$B$14=D2,$C$1:$C$14))

HTH

Steve

[meweaver27]

thanks a lot! Big help! I think it was not working for me becasue i switched it on my real sheet to lookup an entire column A:A rather than a range from A1:A1235

[Teethless mama]

thanks a lot! Big help! I think it was not working for me becasue i switched it on my real sheet to lookup an entire column A:A rather than a range from A1:A1235

It will not work with an entire column, the maximum you can use is A1:A65535

[meweaver27]

thanks again for the quick responses. Helped a lot!