PDA

View Full Version : Excel Lists



chi
07-19-2007, 11:28 AM
I have created a validation list in one cell. If I make a selection from the list, I want the cell next to it to have the sub-categories available in a list format. I think I need to use an if statement but I dont know how. Please see example:
A1: Hondas B1: Civic B2: Accord B3: Odyssy
A2: Toyotas B1: Camry B2: Corolla B3: Prius
A3: Fords B1: Mustang B2: Taurus B3: Focus

Bob Phillips
07-19-2007, 01:29 PM
See http://www.contextures.com/xlDataVal02.html

chi
07-19-2007, 01:31 PM
Thank you much! It is appreciated.

chi
07-19-2007, 02:33 PM
okay, so i tried the formula for the dependant list, but its not working for me. I've attached the list I am working with. Please help.

lucas
07-19-2007, 02:48 PM
Hello chi,
I find no validation list in the file you posted. You probably need to give us a little more of an idea of what you want to do with the data on the sheet as there is no Honda -civic, etc. So I'm not sure how you wish to organize the data that is there.

chi
07-19-2007, 02:56 PM
Ofcourse, sorry about that.
I can get the categories (A1:A5) into a validation okay, but for the dependant list (B1:G5), I am not able to get the list to show. I'm not sure which formula to use. Ive tried a few formulas in the validation list and have re-arranged my list around, but now, im just frustrated.
I've re-attached the excel sample document.

Bob Phillips
07-19-2007, 03:05 PM
Formula? Did you read that page?