I'm trying to do a 2 way match using VBA, the lookup range is dynamic.

Both lastRow and lookUpvalue are set as double

lastRow = Worksheets("TPHPivot").UsedRange.Rows.Count

For i = 2 To Worksheets("RoutingSpeed_MP").Range("G" & Rows.Count).End(xlUp).Row
   
lookUpvalue = Application.WorksheetFunction.Index(Worksheets("TPHPivot").Range("E1001:P" & lastRow), Application.WorksheetFunction.Match(Worksheets("TPHEdit").Range("B" & i), Worksheets("TPHPivot").Range("D1001:D"), 0), Application.WorksheetFunction.Match(Worksheets("TPHEdit").Range("F" & i), Worksheets("TPHPivot").Range("E1000:P1000"), 0))

...

Next i
Not sure if the ranges are not written correctly. any help is appreciated. Thanks