Results 1 to 6 of 6

Thread: How to VLOOKUP specific month and year to find a value?

  1. #1
    New Member
    Join Date
    Jul 2019
    Location
    Singapore
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to VLOOKUP specific month and year to find a value?

    Hi,

    I needed help and appreciate if someone could help me. Suppose the "search key" is 2 Feb 2019, and:

    Column:A Column:B
    1 Feb 2019 $1,000
    2 Feb 2019 $2,000
    3 Feb 2019 $3,000

    How can I use VLOOKUP, or any other formula if needed to get "$2,000"?


    Thanks in advance!
    Last edited by Ray92; Aug 5th, 2019 at 02:36 PM.

  2. #2
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,371
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to VLOOKUP specific month and year to find a value?

    Cross posted https://www.excelforum.com/excel-gen...d-a-value.html

    While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
    This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  3. #3
    New Member
    Join Date
    Jul 2019
    Location
    Singapore
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to VLOOKUP specific month and year to find a value?

    I apologized for the incorrect input. Here is the revised data.

    Suppose the "search key" is 2 Feb 2019 again:

    Column:A Column:B
    1 Jan 2019 $1,000
    1 Feb 2019 $2,000
    1 Mar 2019 $3,000

    How can i get the "$2,000" by looking up for the month and year?


    Thanks in advance!


    https://www.excelforum.com/excel-gen...ml#post5170385

  4. #4
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,371
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to VLOOKUP specific month and year to find a value?

    If your table of dates are always the 1st of the month
    ABCD
    102/02/2019
    201/01/201910002000
    301/02/20192000
    401/03/20193000

    List



    Worksheet Formulas
    CellFormula
    D2=INDEX(B2:B4,MATCH(EOMONTH(D1,-1)+1,A2:A4,0))

    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  5. #5
    New Member
    Join Date
    Jul 2019
    Location
    Singapore
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to VLOOKUP specific month and year to find a value?

    Hi Fluff,

    Thank you. It worked perfectly!

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,371
    Post Thanks / Like
    Mentioned
    471 Post(s)
    Tagged
    47 Thread(s)

    Default Re: How to VLOOKUP specific month and year to find a value?

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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