I have multi row, multi column table. I am looking for the min value with
the formula below and want the output to be the earliest year..

{=MIN(IF((Worksheet!$A$2:$A$1967=A13)*(Worksheet!$ E$2:$E$19670),YEAR(Worksheet!$E$2:$E$1967),""))}

It works for a few rows, but for the most part I get "#value!"

Not sure why.