vlookup for repeating value

[noa210]

Hi,
I'm wondering if there is a way to use vlookup to return the minimum value from an arrey and not the first value.
For example:

order	date
1130	08/11/2017
1130	08/11/2017
1130	05/11/2017
1130	12/11/2017
1129
1129	10/11/2017
1129	06/11/2017
			value	vlookup	<form name="text_form" id="gt-form" action="/" encType="application/x-www-form-urlencoded" method="post">required date </form>
			1130	08/11/2017	05/11/2017
			1129		06/11/2017

<tbody>
</tbody>

Thank you,
Noa

 

[Scott T]

Excel 2010

	A	B
1	order	date
2	1130	8/11/2017
3	1130	8/11/2017
4	1130	5/11/2017
5	1130	12/11/2017
6	1129
7	1129	10/11/2017
8	1129	6/11/2017
9
10
11	Value
12	1130	5/11/2017
13	1129	6/11/2017

<tbody>
</tbody>

Sheet4​

Array Formulas Cell Formula B12 {=MIN(IF($A$2:$A$8=A12,IF($B$2:$B$8<>"",$B$2:$B$8,99999999)))} B13 {=MIN(IF($A$2:$A$8=A13,IF($B$2:$B$8<>"",$B$2:$B$8,99999999)))} <tbody> </tbody> Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}. Note: Do not try and enter the {} manually yourself

<tbody>
</tbody>

 

[noa210]

Thank you, but sadly it doesnt help me...
I need to use vlookup becouse the original data is much bigger and the number of cells in the arreys is not constant...