As per Glenn's reply:
=IF($A2542="","",DATE(INDEX(INDIRECT("'"&$A2542&" Moths'!V3:V12000"),MATCH(MIN(IF(INDIRECT("'"&$A2542&" Moths'!E3:E12000")=index!$E2542,INDIRECT("'"&$A2542&" Moths'!U3:U12000"))),INDIRECT("'"&$A2542&" Moths'!U3:U12000"),0)),1,MIN(IF(INDIRECT("'"&$A2542&" Moths'!E3:E12000")=index!$E2542,INDIRECT("'"&$A2542&" Moths'!U3:U12000")))))
This formula needs now to test for "Micro Moths","Macro Moths" and now "Butterflies" (not Butterfly): it is going to be a bit "messy" (long) Unless you type the full text e.g "Micro Moths" in column A: the formula below will suffice.
Bookmarks