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

"JeffH" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>