Drop List Referencing
 

I would like to use two drop boxes. One for a list of makes and the
second for a list of models. My dilema is that I would like the 2nd
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 will
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 and
can not get this to work.

Any suggestions would be greatly appreciated.


--
Boony
------------------------------------------------------------------------
Boony's Profile: http://www.excelforum.com/member.php...o&userid=16231
View this thread: http://www.excelforum.com/showthread...hreadid=276416

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Boony" schrieb im Newsbeitrag
...

I would like to use two drop boxes. One for a list of makes and the
second for a list of models. My dilema is that I would like the 2nd
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 will
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
and
can not get this to work.

Any suggestions would be greatly appreciated.


--
Boony
---------------------------------------------------------------------
---
Boony's Profile:
http://www.excelforum.com/member.php...o&userid=16231
View this thread:
http://www.excelforum.com/showthread...hreadid=276416

Hi Boony

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

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

Cheers
JulieD

"Boony" wrote in message
...

I would like to use two drop boxes. One for a list of makes and the
second for a list of models. My dilema is that I would like the 2nd
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 will
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 and
can not get this to work.

Any suggestions would be greatly appreciated.


--
Boony
------------------------------------------------------------------------
Boony's Profile:
http://www.excelforum.com/member.php...o&userid=16231
View this thread: http://www.excelforum.com/showthread...hreadid=276416