Drop List Referencing

[Boony]

I would like to use two drop boxes. One for a list of makes and th
second for a list of models. My dilema is that I would like the 2n
drop list to reference the selection made in the 1st drop list.

IE. Drop list 1 contains "ford, chevrolet, dodge, etc."

Now when you pick one of the makes ie. ford, the 2nd drop list wil
give you a list of only the ford models ie. mustang, thunderbird
f-150, etc

I have been trying to use the match, vlookup, and hlookup functions an
can not get this to work.

Any suggestions would be greatly appreciated

 

[Frank Kabel]

Hi
see:
http://www.contextures.com/xlDataVal02.html
and
http://www.xldynamic.com/source/xld.Dropdowns.html

 

[JulieD]

Hi Boony

check out Debra Dalgleish's site on dependent lists using Data / Validation

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

Cheers
JulieD