I had this script set up in an excel sheet that quickly jumped to the corresponding record in another table when double clicking on a cell with an index formula that pulled the results from the said table (thanks to help from this site). It worked brilliantly. However, it does not work in the cloud or on tablets, like anything VBA. So I have turned to Google sheets to see if I can replicate the file. I am currently stuck on this VBA script. Is there anyone here who is proficient with Google Sheets that can help me turn this VBA into a GAS scripts if at all possible. Or know of any alternatives. I've asked on Google forums but not having much luck.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim Parm As String, _
FoundRow As Long
Parm = Target.Value

With Sheets("Jobs Database")
.Select
.Range("A1").Select
.Cells.Find( _
What:=Parm, _
After:=ActiveCell, _
LookIn:=xlValues, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False).Activate
FoundRow = ActiveCell.Row
ActiveCell.EntireRow.Select
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=ROW()=" & FoundRow
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.ThemeColor = xlThemeColorAccent5
.TintAndShade = 0.599963377788629
End With
End With
End Sub

Thank you