MIN Date formula

[McBee1989]

Hi all,

Struggling a bit with retrieveing a the MIN date for a value that has multiple dates. I have a list of values on one tab and on another, i have a further list of values with dates attached. I need my formula to look for the value from tab 1 on tab 2 and then, return the MIN date from the several dates it finds for that value in tab 2. I have copied some code and tried to amend but to be honest, it just returns 0 and I can't get my head around it for some reason!

=MAX(IF(F2='A&E_010418_310718'!$A$2:$A$31402,IF(E2='A&E_010418_310718'!$B$2:$B$31402,values)))

Any help please?

Thanks

 

[oldbrewer]

make up some pretend data eg cols a to e is tab1 cols h to m is tab 2

 

[McBee1989]

Sorry, I should of done that in the first place to make it easier. I have solved my own problem after a long time of trying however I now need to wrap an IF statement in there to remove the 00/01/00 I get when the match is blank?

{ =MIN(IF(TAB1'!$A$2:$A$10=F2,'TAB1'!$B$2:$B$10)) }

 

[oldbrewer]

use if(iserror(..........