Thread: look up formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jane Griffel[_2_] Jane Griffel[_2_] is offline
external usenet poster
 
Posts: 12
Default look up formula

I have two customers with two different list of procedures on one report.
cell A1 has a drop down list of the customers when a certain customer is
chosen How do I write a formula so that when I choose Cutomer 1 only their
list of procedures show up in a drop down box in my procedure area.