Maybe dependant lists using Data Validation?
http://www.contextures.com/xlDataVal01.html

Ed


On Jul 15, 12:56*pm, mommatee
wrote:
Each person in my dept (approx 10 people) are assigned codes that they are
responsible for. *For example: *John Smith's codes are 080, 116P and 114. *
Jane Doe's codes are 115AB, 11D, 10PI and 1586D, etc.) *If someone needs to
get information on someone else's code, we send them an email. *To eliminate
having to send emails, I'd like to create a shared worksheet that allows each
of us to type the code needing information in column A. I'd like the cells in
column B to automatically fill in the person that's responsible for the code
typed in column A.

So, if I type the following in column A, it will provide me with info in
column B
(A1) 11D * * * * (B1) Jane Doe
(A2) 116P * * * *(B2) John Smith

This will tell Jane Doe to provide whatever info is needed on her code 11D
and John Smith will provide whatever info is needed on his code 116P.

I basically want to do something like conditioning formatting.

Thanks for any help anyone can give me.