"PAL" wrote:
.. sometimes there are a few blank values that come up in column L
and causes the output to be 1900. Is there away to make them blanks?
Specifically, ignore the blanks.

Try adding the check on "col L 0" like this, array-entered:
=MIN(IF((Export!$A$2:$A$283=A3)*(Export!$L$2:$L$28 30),YEAR(Export!$L$2:$L$283)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---