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

J

Jamba

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
 
B

Biff

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
 
Top