Results 1 to 4 of 4

Vlookup formula with 2 if statements to pull values for a cetain month of the year.

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    Boston , MA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Vlookup formula with 2 if statements to pull values for a cetain month of the year.

    Trying to get The Look val IE : 1 to display the Value in Column E for only January. Any help would be greatly appreicated. The formula is not working 100%. Any help would be greatly appreciated!
    =IF(MONTH(VLOOKUP(J4,$D$4:$F$18,2,FALSE))=1,IF(ISNA(VLOOKUP(J4,$D$4:$F$18,3,FALSE))=TRUE,0,VLOOKUP(J4,$D$4:$F$18,3,FALSE)),0


    COL D COL E COL E
    Lookup Val JAN Feb March
    1 01/02/2013 25 1 25 0 #N/A #N/A
    2 02/04/2013 50 15 0 375
    3 03/01/2013 75 6 0 0
    4 05/01/2013 100 3 0 0
    1 04/01/2013 125 7 0 0
    6 12/01/2013 150 1 25 0
    7 12/01/2013 175 8 0 0
    8 04/02/2013 200 11 0 0
    9 12/01/2013 225 13 325 0
    1 12/01/2013 250 14 #N/A #N/A
    11 12/01/2013 275 10 #N/A #N/A
    12 12/01/2013 300 2 0 50
    13 01/01/2013 325 4 0 0
    1 06/01/2013 350 9 0 0
    15 02/01/2013 375 9 0 0
    Last edited by dimare13; 11-26-2013 at 02:27 PM. Reason: incorrect subject

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Correct/Working (Index,Match) formula not working between cells
    By barnerd in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-11-2014, 01:20 PM
  2. Working formula for 2007 not working in 2003, SumIfs not available in 2003: Can it be ??
    By Spreadlover in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-05-2013, 06:06 PM
  3. Replies: 9
    Last Post: 03-08-2013, 11:50 AM
  4. Replies: 2
    Last Post: 08-17-2012, 08:16 AM
  5. Replies: 2
    Last Post: 08-01-2012, 11:53 AM

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