Something like this should work in Column B of Worksheet 2:

=VLOOKUP(A1,'Worksheet1'!$A$1:$B$100,2,FALSE)

Adjust the range to fit your needs, then copy down Column B as far as
needed.

HTH,
Elkar


"Daniel- Sydney" wrote:

Hi

I have Excel 2003 SP2.
I am struggling with VLOOKUP,

In worksheet 1, I have column A with codes and column B with names in the
adjacent cells.

On worksheet 2 I have the same codes, listed several times in column A and I
need to import the names from column B on spreadsheet 1 onto column B on
spreadsheet 2 adjacent to the relevant code in column A.

Hope someone can help me with this.

thanks and regards