Can Excel do 'lookups' and show different data depending upon thecell with the focus?
You wouldn't do it with a lookup() function.
You'd do it with a
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
Detect the current cell address, and update the value of D1
accordingly.
|