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!


+-------------------------------------------------------------------+
|Filename: Excel question.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5133 |
+-------------------------------------------------------------------+

--
karstens
------------------------------------------------------------------------
karstens's Profile: http://www.excelforum.com/member.php...o&userid=17657
View this thread: http://www.excelforum.com/showthread...hreadid=566781