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!!!!

See

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

In article . com,
wrote:

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!!!!

On Feb 15, 8:09 am, JE McGimpsey wrote:
See

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

In article . com,

wrote:
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!!!!

Huge!! Thanks a mil

Take a look he

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

HTH

" wrote:

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!!!!

See the instructions for creating Dependent Lists at Debra Dalgleish's website:
http://www.contextures.com/xlDataVal02.html

Post back with more questions.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


" wrote:

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!!!!