Results 1 to 7 of 7

Vlookup Month and Year in a Date

Threaded View

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    19

    Vlookup Month and Year in a Date

    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
    Last edited by deanstein; 09-14-2012 at 03:42 AM.

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