Lookup Up Set Value Go to Source Cell VBA

Hello,

Is there a way to look up a fixed value and go to the source cell in a spreadsheet?

Ex. in Vlookup it would be (vlookup="NY",A:Z,15,0)

So I want to look up column containing NY and give me the result in column 15.

Any help would be amazing!

You would do something like this but you left out some information:

How do you want to specify what "fixed value" it should search for?
What action do you want to trigger this? Push a button? Change a value?

Private Sub gotoit()

   Dim Found As Range
   Dim S As String
   
   S = "NY"
   
   Set Found = Range("A:A").Find(what:=S, LookIn:=xlValues, lookat:=xlWhole)
   If Found Is Nothing Then
      MsgBox S & " was not found"
   Else
      Cells(Found.Row, "O").Select
   End If


End Sub

If you name the pictures according to the state they represent this could be straightforward in VBA. You would have them all call the same Sub and then modify the above code as shown:

Private Sub gotoit()

   Dim Found As Range
   Dim S As String
   
   S = Application.Caller
   
   Set Found = Sheet1.Range("A:A").Find(what:=S, LookIn:=xlValues, lookat:=xlWhole)
   If Found Is Nothing Then
      MsgBox S & " was not found"
   Else
      Cells(Found.Row, "O").Select
   End If


End Sub

Change Sheet1 to whatever sheet contains your data.