Can someone explain me who to change my vlookup formula into a dictionary in order to improve speed?


LastColMyFile = Workbooks(MyFile).Worksheets("Hoja1").Cells(12, Columns.Count).End(xlToLeft).Column
LastRowBase = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row
Range(Cells(13, 7), Cells(LastRowBase, LastColMyFile)).Formula = "=+VLOOKUP(RC1,[" & MyFile & "]Hoja1!R13C1:R500C50,+COLUMN([" & MyFile & "]Hoja1!R[1]C),FALSE)"
Workbooks(MyFile).Close SaveChanges:=False