Ive nver use the index formula on vba. Can you explian mi a little bit more this: "..somewhere in ThisWorkbook, use the column immediately to the right of it to store sequential integers from 1 to 488, sort that 2-column range on its 1st column in ascending order, then use range matches in that range's 1st column to get the row indices in that range's 2nd column for the range in MyFile. That is, with that other range set as the VBA variable xrng"