I'm attempting to do a conditional index-match, where I am looking for information in one workbook, and transfer it to another. Some background:
-I am looking for a project number in Column D (there can be several entries under this number)
-Coordinate that with the type of project in Column F
-Find the corresponding date in Column O
-Then place the date into a different workbook

This doesn't seem to give me any returns, and I can't figure out exactly why. Here's the code:
Set DSTwb = Workbooks.Open(DST)
    Set DSTsh = DSTwb.Worksheets(1)
    DSTlastrow = DSTsh.Range("D50000").End(xlUp).Row

    PIDrg = MPLsh.Range("A2:A" & MPLlastrow)
    DST1rg = DSTsh.Range("O2:O" & DSTlastrow)
    DST2rg = DSTsh.Range("D2:D" & DSTlastrow)
    DST3rg = DSTsh.Range("F2:F" & DSTlastrow)

    Row = MPLsh.Range("B2").Row
    For Each d In PIDrg
        With Application.WorksheetFunction
            Col = MPLsh.Range("AH2").Column
            Var1 = .Match(1, (d = DST2rg) * ("SitePrep" = DST3rg), 0)
            Result = .Index(DST1rg, Var1)
            MPLsh.Cells(Row, Col).Evaluate = .IfError(Result, "")
            Row = Row + 1
        End With
    Next d