return the staff # to the right of the names

[Guest]

I have a workbook with 2 sheets, one sheet named “sheet1â€, another named “sheet2â€.
In sheet 1, I have 2 columns. Column A is the names, column B is the Staff #.s
A B
1 Name Staff Number
2 Tom 235
3 Jack 345
4 Linda 888
…
In sheet 2, I have the names in column A, but the column B is empty:
A B
1 Name Staff Number
2 Jack
3 Linda
4 Joe
…
In sheet 2, column B, I want the computer to return me the correspond staff numbers which are listed in sheet 1: I want 345 in B2, 888 in B3.

 

[David McRitchie]

See my page on VLOOKUP
http://www.mvps.org/dmcritchie/excel/vlookup.htm
and please sign your name at the end so we can refer to you by your name.

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Sheet2 B2:
=VLOOKUP(B1, sheet1!A$1:B$30,2,0)
use the fill handle to fill down as needed.

 

[Karl]

B2 =VLOOKUP(A2,Sheet1!$A$2:$B$4,2,FALSE)

I have a workbook with 2 sheets, one sheet named "sheet1", another named "sheet2".
In sheet 1, I have 2 columns. Column A is the names, column B is the Staff #.s
A B
1 Name Staff Number
2 Tom 235
3 Jack 345
4 Linda 888
.
In sheet 2, I have the names in column A, but the column B is empty:
A B
1 Name Staff Number
2 Jack
3 Linda
4 Joe
.
In sheet 2, column B, I want the computer to return me the correspond

staff numbers which are listed in sheet 1: I want 345 in B2, 888 in B3.