List Vlookup ??

[gmata]

Is there any chance I can have a List lookup another list??

For example:

I have dropdown List 1

Airplane
Boat
Car


If I select Airplane on the next dropdown list 1 can it change dropdown list 2 to airplane parts?

Wings
Fuselage
Rudder

But if I select "Car" the dropdown list 2 changes to only car parts

Transmission
Tires
Radiator

Thanks

[teylyn]

Hello,

what you describe is called dependent data validation and can be built with named ranges and careful data layout. Debra Dahlgliesh has a step by step tutorial here:

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

cheers, teylyn

[gmata]

Sorry, Found the answer already

Data Validation =Indirect

[sandy666]

you can play with
=CHOOSE(MATCH(B2,J1:J3,0),K1:K3,L1:L3,M1:M3)
where
J1:J3 is a main list
K1:K3, L1:L3 and M1:M3 are the lists of parts

[azumi]

And what is Boat part?