如果需要在Sheet1的B2单元格显示Sheet2的C列的最后一个数据，那么输入数值输入=LOOKUP(9e+307,Sheet2!C:C)文本输入=LOOKUP("座",Sheet2!C:C)或者返回Sheet2的C列最后一个非空单元格，输入=LOOKUP(1,0/(Sheet2!C:C<>""),Sheet2!C:C)
