Here is what i got:

a6
=IF(ISERROR(VLOOKUP($D$4,Functions!$B2:$L$100,1,FA LSE)),"",VLOOKUP($D$4,Functions!$B2:$L$100,1,FALSE ))

a7
=IF(ISERROR(VLOOKUP($D$4,Functions!$B3:$L$100,1,FA LSE)),"",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=11
etc..

Functions!B3= Month number for jobs, so there could be 12 jobs for
October.

a6:a100 is adv. filtered by D4.

OK, here is my problem, the way the fromulas are in a6:a100 i get the
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 without
repeating?


--
comotoman
------------------------------------------------------------------------
comotoman's Profile: http://www.excelforum.com/member.php...o&userid=27292
View this thread: http://www.excelforum.com/showthread...hreadid=473033