VLOOKUP Function to select the cell that has been found

[nosense]

Hi there,

I need Lookup to select the cell that has been matched with lookedup value so i am able to assign a new value within such cell.
so far i got

/code

Sub waste()
Dim ra As range, val As String





Sheets(1).Select


 Set ra = Sheets("resin").range("d2:p100")
    
val = Sheets("Manufacturing").range("d9")

result = Application.WorksheetFunction.VLookup(val, ra, 13)

Range(result).select '----> it does not like this part:(


'Sheets(1).range("K9") = result

/code