Hi All
I want to create a drop down list and when an item is chosen it changes a formula to display a different date.
We use 2 different date codes one for our own products and one for customere products, would it be possible to create a drop down list so if "Customer Brand" is chosen the formula is changed in another cell so the correct date is shown and then if "Own Brand" is selected the same cell changes to the relevent date code.
Customer brand selected in F4 date in C7 changes to 17.10.2011, Own Brand selected in F4, C7 changes to 31.10.2011. The dates are calculated by formula so must be linked to drop down list in some way.
Thanks for any help
Bookmarks