View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Daniel- Sydney Daniel- Sydney is offline
external usenet poster
 
Posts: 14
Default Adding into another column (VLOOKUP)

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