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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add text automatically by recognized value 4
Vlookup and return sheet name also 2
Match a value to multple criteria both in rows and columns 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
Adding up total hours worked on employee schedule using various criteria 0
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Excel Is this possible?? 3
Manipulating Text to create HLOOKUP 8

Back
Top