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
Bookmarks