Vlookup Month and Year in a Date

[deanstein]

Hi All

If i have the following data:

	A	B
1	2012-05-15	100
2	2012-05-22	103
3	2012-05-29	96
4	2012-06-04	110
5	2012-06-22	85
6	2012-07-15	102
7	2012-07-17	109
8	2012-07-20	115
9	2012-07-23	97
10	2012-07-31	99
11	2012-08-25	89
13	2012-08-27	102
14	2012-09-12	129

How can I use a vlookup to extract only the July 2012 rows? So in other words to get the following table (basically as if i was using the excel filter function to filter out the month and year):

1	2012-07	102
2	2012-07	109
3	2012-07	115
4	2012-07	97
5	2012-07	99

Thanks in advance

[Fotis1991]

Hello

One way is this. Look at my sample.

Is it OK for you?

[deanstein]

Exactly what I was looking for! Thank you very much!

[Fotis1991]

You are welcome!

[deanstein]

Hi Fotis

I thought everything was working but then tested the year part of the date and it doesn't seem to be doing anything

Please help!

[Fotis1991]

Apologize! Wronk sample! Don't worry.

Here is the correct.

[deanstein]

Thank you very much! Works like a charm now