ello peepz

uhm im currently not an EXCEL savant but id really like to know how. uhm i already tried some help topics from excel so far so good but i currently have some questions... any help is appreciated...

how to:
[cell 1] has to have 2 or more options available through a drop down menu(i.e., A, B, & C)
[cell 2] cell 2 is also a drop down menu that has to depend on cell1. if cell 1 is A, cell 2 will display drop down menu with options 1,2,3. if cell1 is B, it will have options 4,5,6 and if cell1 is C, cell2 will have 7,8,9.(note: 1,2,3,4,5,6,7,8,9 are not numeric though. all are text)

thank you for any help.