Pick Lists value dependant on another cell

[woodfc]

Hello. I have a column called "Part Number". This number is composed of many components to create the number (CB-U-5-1234). These components are part of pick lists in different columns (one column per number component)on my spreadsheet. I would like the users to be able to enter the part number and have the other columns filled in based on this number. So for the example above, the column "Item Type" would be populated with "CB - Cabling" automatically because "CB" is used in the part number column. I know I could do it the other way but our users like to use part number so it would save the hassle of going to pick all the different values.

Hope someone can help.

 

[Steve=True]

YOu can do this with a series of look up tables and formulas that parse the item number up to look up a value.

I would suggest posting a sample file so that the users can assist.

www.4shared.com

 

[woodfc]

Thanks for your reply! I'm new to this so how do I go about attaching a file?

Cathy

 

[Steve=True]

Goto that four shared link anove and post your file and it gives you a link