Need help searching another sheet and retrieving a value

  • Thread starter Thread starter JeffH
  • Start date Start date
J

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.
 
Back
Top