I am not sure, I may be able to do that. I have some programming running in
Visual Basic so that my rows are color coordinated based on their
progressions through the system, and considering that for the examples we
have 15 workers and each worker including myself is assigned a range of
numbers for the caseloads. Each caseload has 10 digits and based on the last
three determines which worker should be handling the case on a regular basis,
each worker has a six didgit ID number. I just want something in the system
so that I don't have to keep looking at my list to figure out who gets what
when I am done with a case.

"Benjamin" wrote:


Can you do this with a Vlookup Formula?

"Judy Cohen" wrote:

I have a spreadsheet detailing all cases a worker has in a given month.
Cases are then managed by their case ID and get alotted to a specific worker
based on the last three digits of the case ID.

Example Case id is 0005551212

Based on the 212 at the end it should be transferred to worker 900111 when
completed.

I want to have a column where for each case it lists the worker that gets
the transfer after entry of the case ID into the Case ID cell.

Right now I just keep looking at my listing and it would be nice to have the
computer do this for me.

Thank you for any help you may be able to give.