Find name in list and get dept # enter dept # on work sheet

Working on a log and would like Excel to find the department number and enter
it into the cell next to name when name is entered into the log. Have
created a list with names in column "A" and department #'s in column "B" .
Sheet 1 named Log
Sheet 2 named Names List

Hi!

Try this:

A1 = some name

=VLOOKUP(A1,'Names List'!A:B,2,0)

To make it more robust try one of these:

=IF(COUNTIF('Names List'!A:A,A1),VLOOKUP(A1,'Names List'!A:B,2,0),"")

=IF(ISNA(MATCH(A1,'Names List'!A:A,0)),"",VLOOKUP(A1,'Names List'!A:B,2,0))

=IF(ISNA(VLOOKUP(A1,'Names List'!A:B,2,0)),"",VLOOKUP(A1,'Names
List'!A:B,2,0))

Biff

"Jamba" <[email protected]> wrote in message
news:[email protected]...
> Working on a log and would like Excel to find the department number and
> enter
> it into the cell next to name when name is entered into the log. Have
> created a list with names in column "A" and department #'s in column "B" .
> Sheet 1 named Log
> Sheet 2 named Names List