Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|