Need help searching another sheet and retrieving a value

[JeffH]

Hello,

I have multple sheets.

Sheet A with
Name, Dept#,Phone,Manager
John Doe, 1105, 123-123-1234, blank

Sheet B with
Dept#,Manager
1105, Mgr John Doe
1123, Mgr Jane Doe

I am to
for each row in sheet a
match a row in sheet b based on the dept#
insert into the manager cell of sheet a with the value from manager
cell sheet b

Any direction would be great. Thanks.

 

[Biff]

Hi!

Try this:

=VLOOKUP(B2,'Sheet B'!A:B,2,0)

Copy down as needed.

Biff