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

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

Great

thanks for your help

regards


"Elkar" wrote:

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

Okay, hopefully I can get a bit more help here, it is not working for me and
I cannot
figure out why.

Given that the data in A and B on worksheet 1 is in rows 2 to 88 and in
worksheet 2 it is 2 to 357, what would I enter.

thanks and regards

"Elkar" wrote:

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

Ok, on worksheet 2, in cell B2 enter the following:

=VLOOKUP(A2,'Worksheet 1'!$A$2:$B$88,2,FALSE)

Does that return the proper result? If not, what is happening? Are you
getting the #N/A error? If so, it may be that your codes on one sheet are
formatted as numbers and on the other sheet they are formatted as text.

Also, if your Worksheet 1 is actually called something else, then you'll
need to change the name in the formula as well.

If it works, then copy the formula in B2 to cells B3 through B357.


"Daniel- Sydney" wrote:

Okay, hopefully I can get a bit more help here, it is not working for me and
I cannot
figure out why.

Given that the data in A and B on worksheet 1 is in rows 2 to 88 and in
worksheet 2 it is 2 to 357, what would I enter.

thanks and regards

"Elkar" wrote:

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

Thanks forn the great help,
it was the name of the worksheet that was the problem,
I appreciate your help amd patience.

regards

"Elkar" wrote:

Ok, on worksheet 2, in cell B2 enter the following:

=VLOOKUP(A2,'Worksheet 1'!$A$2:$B$88,2,FALSE)

Does that return the proper result? If not, what is happening? Are you
getting the #N/A error? If so, it may be that your codes on one sheet are
formatted as numbers and on the other sheet they are formatted as text.

Also, if your Worksheet 1 is actually called something else, then you'll
need to change the name in the formula as well.

If it works, then copy the formula in B2 to cells B3 through B357.


"Daniel- Sydney" wrote:

Okay, hopefully I can get a bit more help here, it is not working for me and
I cannot
figure out why.

Given that the data in A and B on worksheet 1 is in rows 2 to 88 and in
worksheet 2 it is 2 to 357, what would I enter.

thanks and regards

"Elkar" wrote:

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