Adding into another column (VLOOKUP)

[Daniel- Sydney]

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

 

[Elkar]

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]

Great

thanks for your help

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]

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]

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]

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

regards