Something like :-

=INDEX(A1:A400,MATCH(z1,C1:C400,0))