VLOOKUP of Date

I have a 2-column data set. The first column contains monthly dates over a period of years in the dd/mm/yy format. The second column contains the data.
In my search-for field I insert a date in the mm/yy format. (I don't want to insert the exact date, just the month and year.) I want to return the data associated with that mm/yy date. How do I ask VLOOKUP to look for the last entry in that particular mm/yy, and then return the pertinent data?

Can you attach a sample showing some data and what you want as your result mocked-up?

Go Advanced -> Manage Attachments -> Upload

I think I attached the file correctly. THANKS for the help.

Try this;

Formula:

Please Login or Register  to view this content.

WONDERFUL, that worked. What I was missing was knowledge of EOMONTH. Now I know!