Get Data based on Month and Year

[karstens]

I have attached a word file showing what I am looking for as I wa
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
promotion to use by going to another worksheet and finding the char
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
+-------------------------------------------------------------------

 

[Fred Smith]

You would use a Vlookup. The specifics depend on exactly how your date is stored
in the Promotion tab.

If it's text, you should be able to use:

=vlookup(text(a2,"mmm-yy"),Promotion!A:B,2,false)

If it's a date, you would need to know which day is stored in the cell. Assuming
it's day 1, you can use:

=vlookup(date(year(a2),month(a2),1),Promotion!A:B,2,false)