Find name in list and get dept # enter dept # on work sheet
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" wrote in message
...
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
|