# Thread: How to VLOOKUP specific month and year to find a value? Thanks:  1 Post #5320562 (1) Likes:  1 Post #5320532 (1)

1. ## 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"?

2. ## 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.

3. ## 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?

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

4. ## 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))

5. ## Re: How to VLOOKUP specific month and year to find a value?

Hi Fluff,

Thank you. It worked perfectly!

6. ## Re: How to VLOOKUP specific month and year to find a value?

You're welcome & thanks for the feedback