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
Bookmarks