OK, thanks for the corrections.
However, none of those formulas return anything.
And I know that in "Student List" there is teacher initial "AC" that in the
AE409:AE419 range.

So once again, is it possible if I type "AC" in cell A2 in "Test" sheet, and the range B2:B15 (assuming 14 rows are returned) are populated with last names from "Student List" which are in B2:B673 range?

Thanks again. (It just bugs me how much time I have spent on this...)