Errata, B2's array formula should be:
Put in B2, array-enter, ie press CTRL+SHIFT+ENTER to confirm the formula:
=INDEX(Sheet1!$B$3:$B$11,MATCH(MIN(IF((Sheet1!$A$3 :$A$11=$B$1)*(Sheet1!$C$3:$C$11TODAY())*(Sheet1!$ C$3:$C$11-TODAY())0,(Sheet1!$A$3:$A$11=$B$1)*(Sheet1!$C$3:$ C$11TODAY())*(Sheet1!$C$3:$C$11-TODAY()))),(Sheet1!$A$3:$A$11=$B$1)*(Sheet1!$C$3:$ C$11TODAY())*(Sheet1!$C$3:$C$11-TODAY()),0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---