Selection in 1st list box populates 2nd list box

M

Matt.Russett

Simplified example of Table

Cars Chevy 1990
Cars Ford 1996
Cars Toyota 2001
Birds Eagle Big
Birds Crow Medium
Birds Chickadee Small

The first list box will be populated with the data from column A
(Cars, Birds)

After selecting "Cars" in column A, I would like a second List box to
populate with the next level of data in column B (Chevy, Ford,
Toyota).

After making that selection I can easily set up a vlookup based on a
key and return the correct value from column C.

The problem I am having is figuring out how to populate the 2nd list
box based on the selection in the 1st.

Does anyone know how to do this?

Thanks!!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top