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:

[TABLE="width: 531"]
<tbody>[TR]
[TD]order
[/TD]
[TD]date
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1130
[/TD]
[TD]08/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1130
[/TD]
[TD]08/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1130
[/TD]
[TD]05/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1130
[/TD]
[TD]12/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1129
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1129
[/TD]
[TD]10/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1129
[/TD]
[TD]06/11/2017
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]value
[/TD]
[TD]vlookup
[/TD]
[TD="align: left"]<form name="text_form" id="gt-form" action="/" encType="application/x-www-form-urlencoded" method="post">required date </form>
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1130
[/TD]
[TD]08/11/2017
[/TD]
[TD]05/11/2017
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1129
[/TD]
[TD][/TD]
[TD]06/11/2017
[/TD]
[/TR]
</tbody>[/TABLE]

Thank you,
Noa

 

[Scott T]

Excel 2010[TABLE="class: grid, width: 300"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[/TR]
[TR]
[TD="align: center"]1
[/TD]
[TD]order
[/TD]
[TD]date
[/TD]
[/TR]
[TR]
[TD="align: center"]2
[/TD]
[TD="align: right"]1130
[/TD]
[TD="align: right"]8/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]3
[/TD]
[TD="align: right"]1130
[/TD]
[TD="align: right"]8/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]4
[/TD]
[TD="align: right"]1130
[/TD]
[TD="align: right"]5/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]5
[/TD]
[TD="align: right"]1130
[/TD]
[TD="align: right"]12/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]6
[/TD]
[TD="align: right"]1129
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]7
[/TD]
[TD="align: right"]1129
[/TD]
[TD="align: right"]10/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]8
[/TD]
[TD="align: right"]1129
[/TD]
[TD="align: right"]6/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]9
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD]Value
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12
[/TD]
[TD="align: right"]1130
[/TD]
[TD="align: right"]5/11/2017
[/TD]
[/TR]
[TR]
[TD="align: center"]13
[/TD]
[TD="align: right"]1129
[/TD]
[TD="align: right"]6/11/2017
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet4​

[TABLE="class: grid, width: 85%"]
<tbody>[TR]
[TD]
Array Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD="width: 10"]Cell
[/TD]
[TD="align: left"]Formula
[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B12
[/TH]
[TD="align: left"]{=MIN(IF($A$2:$A$8=A12,IF($B$2:$B$8<>"",$B$2:$B$8,99999999)))}
[/TD]
[/TR]
[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]B13
[/TH]
[TD="align: left"]{=MIN(IF($A$2:$A$8=A13,IF($B$2:$B$8<>"",$B$2:$B$8,99999999)))}
[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

 

[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...