I want to be able to look up a cell in excel then go to another c.
 

jI WANT TO BE ABLE TO ISE SOMETHING LIKE THIS @IF G10 =G160, GOTO J160

Something has to trigger Excel to evaluate G10=G160 and
then select J160 if it is TRUE. What will trigger it? One
possibility is a Worksheet_Change event so that if cells
G10 or G160 are changed by the user, the macro will fire.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G10,G160")) _
Is Nothing Then
If Me.[G10].Value = [G160].Value Then
Me.[J160].Select
End If
End If
End Sub


---
To use, right-click on the worksheet tab and choose "View
Code". Paste in the code above and press ALT+Q to close
VBE.

HTH
Jason
Atlanta, GA

-----Original Message-----
jI WANT TO BE ABLE TO ISE SOMETHING LIKE THIS @IF G10
=G160, GOTO J160
.