trying to create nested formula using address match vlookup

I'm trying to create a formula that I can use to reference a cells. Not getting this to work, any help would be appreciated

=MIN((ADDRESS(MATCH(VLOOKUP(A47837-1,A:A,1,FALSE),A:A,0)+10,16)):(ADDRESS(MATCH(VLOOKUP(A47837,A:A,1,FALSE),A:A,0)-1,16)))

Individually the formula =(ADDRESS(MATCH(VLOOKUP(B47837-1,B:B,1,FALSE),B:B,0)+10,16)) and =(ADDRESS(MATCH(VLOOKUP(B47837,B:B,1,FALSE),B:B,0)-1,16)) work to provide the cells references.

$P$44057
$P$47836

cell A44047 = a date/time 27/3/2014 23:59:59
cell A47837 = a date/time 28/3/2014 23:59:59

cells A44047 thru A47837 are dated 28/3/2014 and are time stamped from midnight increasing in by the minute

cells P44057 thru P47837 are date stamped cells representing the start and finish times for the power production of my solar panels.

manual formula reads =MIN(P44057:P47836)

Thanks, John

Jeff,

Thanks for that option 1 works a treat. Option 2 came up with the data for the wrong date.

Again thanks

John

FWIW martindwilson has the best solution here--in this case VLOOKUP is superfluous.