C18输入
=INDEX(A:A,MATCH(LOOKUP(9^9,B:B),B:B,))
C18输入=INDEX(A:A,MATCH(9^9,B:B))
用数组公式来做。C13输入：=INDIRECT("A"&MAX(IF(B19:B65536<>"",ROW(A19:A65536),0)))再同时按下Alt + Ctrl + Enter
