Hey all,

I want to set a range of possible Numerical cell entries in C2 to be
converted into different Numerical Cell entries in D2 and E2 by use of
formulas.

Example:
C2="8320-0-5-51" which is a logical equipment number in a packet switch.
D2="SW-1" which is the physical packet switch ID.
E2="Port 1" which is the physical port number on the identified
switch.

In other words if one of my technicians enters the 'logical' equipment ID I
would like the 'physical' switch ID created by use of formulas in D2 and the
'physical' port number created in E2.

My question is can this be done? If so how do I go about it? I have been
trying to educate myself without any books and I am slowly getting nowhere.
Any help would be appreciated.

Thanks,
Todd M. Garthaffner