Create a Sub List from a drop down list

I need to create a 'sub' list from a drop down list.
I have 8 categories in a drop down list in column A, but i need column B to also have a drop down list of sub categories depending on what category is selected in column A.

And once column B is populated, i need column C to auto populate with a value. All data is stored on the spreadsheet.

Try here:
http://www.ozgrid.com/Excel/dependent-lists.htm

No point in me copy-pasting!

HTH

I actually just did it using that exact link. Thanks a heap! But i now have another issue,

once the sub-list has been defined, I need a known value to be automatically enetered into the next column. Column A, B and C are all specific to each other... Still with me?

Yes,

Will a formula suffice (along the lines of 'if column b value = apple then pie, else flan') or do you want a singular value entry (using VBA the value is automatically entered when column B is populated)?

Bear in mind VBA is not very portable as most users have security settings on High as per default.

CC

formula will do fine i think? will i have to do each rule individually? There are 18 values. Im not very cluey when it comes to formulas in excel. I tried =IF(A1=BLA:B2=BLABLA,B3=VALUE) . have no idea...

sorry to butt in
but what happens when you want to do another dependant set ?
the example uses 2 drop downs how about if you want multiple?

you can create further lists, see

http://www.contextures.com/xlDataval02.html


I still cant work out the formula for column C. Once A and B are selected, I need column C to populate. (C is dependant on A and B)

=indirect(substitute(a2&b2," ",""))

You'll probably want a lookup - but it might be easier to explain if you post a small example

HTH