Look in help for Vlookup.

Regards,
Fred.

"Jesse" wrote in message
...
I am trying to search a list of names (1200 names) for an exact match then
return back a department number. For instance if John Doe works in Dept.
10.
I want to type in "John Doe" on my list in tab 1 and the next cell with
this
formulas will search the list of names and return "10". Please help! Thank
you!