Drop Down Menus with IF Structure?

Hello all-

This being my first post, and extremely new to this community, I'd just like to say that any help on this topic would be greatly appreciated.

I'm working on a spreadsheet I've kept for several years dealing with my personal accounting. I have columns set up such as "Date", "Time", "State", "City", "Establishment", & "Address", among others. It is naturally more then I need to keep a balanced checkbook, but it's helped me really get accustomed to Excel & I've had a fun time making it better & better over the years.

My question for this forum is: Is there a way that I can incorporate drop down menus in order to select a State, and then in the next column, be able to select a certain City that belongs to that state?

For instance, I live in Virginia, and this is where 90% of my purchases occur. Could I select "VA" from a drop down menu, and in the next column, be able to have a drop down menu that lists cities only pertinent to the state of Virginia?

I've been able to create drop downs using validation, but I'm unsure how I can make them dependent on variables, only selecting from a list.

Ultimately I'd like to be able to select a state of purchase from a menu, then a city in the next column (limiting only to Cities within the State I selected in the previous column), followed by an establishment in the next column (which would only show those establishments I've been to in that specific City I selected in the previous column), and then a specific address of that establishment in the next one, and so forth.

Any help would again be greatly appreciated... and if this description was not enough, and you need more information, please msg me, thanks!

-CaveMaN

See http://www.contextures.com/xlDataVal02.html

Thank you sir, that looks exactly like what I was looking for