用VB解决:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 1 And Target <> "" Then
Range("H2").Formula = "=LOOKUP(A2,Sheet2!H2:H8,Sheet2!I2:I8)"
End If
End Sub
用VB解决:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 2 And Target.Column = 1 And Target <> "" Then
Range("H2").Formula = "=LOOKUP(A2,Sheet2!H2:H8,Sheet2!I2:I8)"
End If
End Sub