Need help searching another sheet and retrieving a value
 

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.


--
JeffH
------------------------------------------------------------------------
JeffH's Profile: http://www.excelforum.com/member.php...o&userid=36866
View this thread: http://www.excelforum.com/showthread...hreadid=565861

Need help searching another sheet and retrieving a value
 

Hi!

Try this:

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

Copy down as needed.

Biff

"JeffH" wrote in
message ...

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.


--
JeffH
------------------------------------------------------------------------
JeffH's Profile:
http://www.excelforum.com/member.php...o&userid=36866
View this thread: http://www.excelforum.com/showthread...hreadid=565861