See Debra Dalgleish's site for help on creating dependent lists.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Sat, 3 Apr 2010 15:23:02 -0700, rmar
wrote:

I am attempting to use the list function within data verification for drop
down menus. I need a list that is conditional upon the information in
another cell.
Example: The first cell offers a drop down menu with specific Make of
equipment. From what appears in that cell I seek to offer only the Models
for that Make of equipment on a list in another cell. I considered using a
series of IF statements to run macros however I don’t know how to invoke a
macro from within a formula. Any suggestions?
Thank You
=if(“Trane”,macro,=If(Crrier,macro,=If(Bitzer,mac ro…)))