VBA Range inside Functions not producing desired results

Hi All,

I have the following code, where I set some Ranges (using 2nd row to Last_row of some columns) and then try to use those ranges in my formulas.

But the macro runs and doesn't give me the desired results, I am sure there is something wrong in the way I have written them. Please have a look let me know what needs to be corrected.

HTML Code: 

If I were to do these functions directly in Excel it would look like:

in I2:
=IFERROR(AGGREGATE(15,6,Diff_Names!$E$2:$E$726/((G2=Diff_Names!$B$2:$B$726)*(E2=Diff_Names!$C$2:$C$726)),1),"N/A")

in J2 (ARRAY):
{=IFERROR(INDEX(Diff_Names!$F$2:$F$726,MATCH(G2&E2&I2,Diff_Names!$B$2:$B$726&Diff_Names!$C$2:$C$726&Diff_Names!$E$2:$E$726,o),1),"N/A")}

In the macro I am just trying to make the last row (726-MyLastRow) dynamic and setting up the ranges to use inside functions.

Thanks a lot, learned something new today.

Have a great day ahead...