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.

look up formula
 

See Debra's article on dynamic validation:
http://www.contextures.com/xldataval02.html

--
Best Regards,

Luke M
"Jane Griffel" wrote in message
...
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.

look up formula
 

Perhaps this...

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

Jim Thomlinson


"Jane Griffel" wrote:

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.

look up formula
 

WOW thanks for the help that is exactly what I needed.

"Jim Thomlinson" wrote:

Perhaps this...

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

Jim Thomlinson


"Jane Griffel" wrote:

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.