Simple Formula Trouble

[Guest]

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

 

[Guest]

The feature you are looking for is called VLOOKUP, and you would need a
VLOOKUP formula in D2 and E2 to return the values you seek. You would also
have to create a VLOOKUP Table, relating all the values of concern.
Depending on how many different values you wish to look up, you may wish to
put a dropdown box in the lookup cell to prevent type-o's, as VLOOKUP can
return errors unless it finds exactly what you're looking
for............www.contextures.com has some instructions on VLOOKUP.

hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

Thank You,

I figured I needed some sort of table since there was a conversion of
'non-real' data involved. I will try what you mentioned.

Thanks once again,
Todd

 

[Guest]

You're welcome.........thanks for the feedback.
Post back if you run into difficulties.........

Vaya con Dios,
Chuck, CABGx3