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
|