Sorry if you've read this. However, I didn't see the question appear in my
reader.

I have a project that includes parsing a .txt file into Excel. Included in
the fields imported is an EmplID. I need to retrieve data from separate
workbooks based on this. My experiment with Index and Match produced slow
results when linked to one other workbook (about a minute for 4000 records).
I am currently looping using i to increment the row number in the lookup
formula.

Is there a faster method (either not using Index/Match or not looping)?

Steve




Steve