Earlier array in K2 seems a little over-roasted
This should suffice:
In K2, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula:
=IF(ISNA(MATCH(MAX(IF(($B$2:$B$31=$J2)*($F$2:$F$31 <""),ROW($A$2:$A$31))),IF(($B$2:$B$31=$J2)*($F$2: $F$31<""),ROW($A$2:$A$31)),0)),"",INDEX(F$2:F$31, MATCH(MAX(IF(($B$2:$B$31=$J2)*($F$2:$F$31<""),ROW ($A$2:$A$31))),IF(($B$2:$B$31=$J2)*($F$2:$F$31<"" ),ROW($A$2:$A$31)),0)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---