Return value based on another vlaue

J

Jesse

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!
 

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

Top