Get Data based on Month and Year
 

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

Get Data based on Month and Year
 

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)

--
Regards,
Fred


"karstens" wrote in
message ...

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