Challenge: I have a column full of sales peoples names. I would like to
write a formula that will identify the persons name in the column and in the
same row, but a different column enter a letter that correspondes to what
type of sales person they are in our organization.

Example: John Smith is listed in the column and he is a National Account
Manager so I would like a formula that recognizes his name and puts "NAM" in
a free cell in his row of information.

Does Excel 2002 have a function that can do this?

Thanks very much.
rich