I'm really not following you guys (and/or girls) here

Lets take it from scratch:

In my MAIN.xls I have column A with i.e. these numbers:

11111

22222

3333

444

555555

66666

Then I have another worksheet in another Excel-document called DATALIST.XLS.

In column A and B is the following info:

943827 Dan

5453 Eric

345 John

65456 Melissa

11111 David

43234 Ron

4343 Carrie

3 Max

34545 Jamie

725487 Bob

Then in MAIN.XLS I'd like a formula that searches the whole column A from my DATALIST.XLS, starting with cell A1 in MAIN.XLS. Then onto cell A2 and so on....

When it finds a identical number, I want the formula to put the info from column B (in DATALIST.XLS) into column C in MAIN.xls.

So in my example I would have the name David to appear in cell C1 in MAIN.XLS.

Actually I've done all this using a macro in VBA.

I could of course put the formula into the cells A1 to A10000 in MAIN.XLS, but the data in MAIN.XLS is different from each time I do this task with this macro of mine. Because I import data from a text file to my MAIN.XLS, and the number of rows in the text file are never the same. Sometimes it could be 163 rows, the next time it could be 6932 rows. See ??

So I only need the VBA code for telling my macro that: After putting in the formula in C1 in MAIN.XLS, I want the same formula to be put into cell C2, C3, C4 and so on.

The formula should of course refer to the data in cell A at the same row as the formula is.

Did that make any more sense or what??

My other problem is that I have the Norwegian version of Excel at work, and are not that familiar with the english trems and words in VBA and Excel.

At home I have english version of Excel, so I just have to put my language skills up for a test now

Appreciate any help on this.