I have attached a word file showing what I am looking for as I was having a hard time trying to lay it all out in here.
I am trying to find a formula that will tell me what percatage of a promotion to use by going to another worksheet and finding the chart that shows the discounts offered in a particular month.
The word file will explain it better.....I hope!
Bookmarks