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 dont know how to invoke a
macro from within a formula. Any suggestions?
Thank You
=if(€œTrane€�,macro,=If(Crrier,macro,=If(Bitzer, macro€¦)))