software

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 quot;Aquot; and department #'s in column quot;Bquot; .
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),quot;quot;)

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

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

Biff

quot;Jambaquot; gt; wrote in message
...
gt; Working on a log and would like Excel to find the department number and
gt; enter
gt; it into the cell next to name when name is entered into the log. Have
gt; created a list with names in column quot;Aquot; and department #'s in column quot;Bquot; .
gt; Sheet 1 named Log
gt; Sheet 2 named Names List