Drop List Referencing

B

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
 
Top