Results 1 to 7 of 7

VLOOKUP Multiple Criteria (Dates)

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-04-2006
    Posts
    151

    VLOOKUP Multiple Criteria (Dates)

    Hello - In column I, there is a list of dates - month and day only

    In column J there is a list of dates, month,day, and year.

    --I----------------J
    1/14----------1/14/2009
    1/14----------1/15/2009
    1/14----------1/16/2009
    1/15----------1/17/2009


    in column K, I am trying to setup a Vlookup statement that states if the month and day in column I = the month and day in column J then return the value in column J.

    I have the following formula, but it just returns N/A.

    =VLOOKUP(AND(MONTH(H1),DAY(H1)),H1:I2001,2,FALSE)
    I have tried different variations and different methods to no avail. I have even tried adding an if statement into the mix. I have tried using direct/match without success and my knowledge of Excel in this area is limited.
    Help is much appreciated. Thank you for your time.
    Last edited by NewExcelUser; 01-23-2009 at 12:50 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