C
comotoman
Here is what i got:
a
=IF(ISERROR(VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE)),"",VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE))
a
=IF(ISERROR(VLOOKUP($D$4,Functions!$B3:$L$100,1,FALSE)),"",VLOOKUP($D$4,Functions!$B3:$L$100,1,FALSE))
and so on, the only change is the lookup area reduces by 1.
d4 is a month number (1-12) based on the current month. oct=10 nov=1
etc..
Functions!B3= Month number for jobs, so there could be 12 jobs fo
October.
a6:a100 is adv. filtered by D4.
OK, here is my problem, the way the fromulas are in a6:a100 i get th
same result on descending lines. example-
a7: 10 Job 3 October 5, 2004
a8: 10 Job 3 October 5, 2004
How can I fix this to get all the results for October withou
repeating
a
=IF(ISERROR(VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE)),"",VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE))
a
=IF(ISERROR(VLOOKUP($D$4,Functions!$B3:$L$100,1,FALSE)),"",VLOOKUP($D$4,Functions!$B3:$L$100,1,FALSE))
and so on, the only change is the lookup area reduces by 1.
d4 is a month number (1-12) based on the current month. oct=10 nov=1
etc..
Functions!B3= Month number for jobs, so there could be 12 jobs fo
October.
a6:a100 is adv. filtered by D4.
OK, here is my problem, the way the fromulas are in a6:a100 i get th
same result on descending lines. example-
a7: 10 Job 3 October 5, 2004
a8: 10 Job 3 October 5, 2004
How can I fix this to get all the results for October withou
repeating