+ Reply to Thread
Results 1 to 3 of 3

Get Data based on Month and Year

  1. #1
    Forum Contributor
    Join Date
    12-21-2004
    Location
    MN
    MS-Off Ver
    Microsoft 365
    Posts
    211

    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!
    Attached Files Attached Files

  2. #2
    Fred Smith
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




  3. #3
    Fred Smith
    Guest

    Re: 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" <[email protected]> wrote in
    message news:[email protected]...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1