What is the format of the drop down selection?

Are they the month names like September?

What about the dates in Log!$B$1:$B$2000, are they all the same year? Do you
want the values returned based solely on the month or month of a specific
year?

Also, your formula is returning values from column A but you're testing
column B for the date.

Biff

"caj" wrote in message
...
I am trying to display all the dates for a particular month from a list.
The
data is accumulated on the Log sheet and is pulled to the Monthly Log
sheet
based on a dropdown.

=INDEX(Log!$A$1:$O$2000,SMALL(IF((Log!$B$1:$B$2000 <($Q$1),
Log!$b$1:$b$2000($Q$2)),ROW(Log!$A$1:$O$2000)),RO W(Log!2:2)),1)

where
q1 is beginning of month
q2 is end of month

How do I set this formula to just pull dates from the month displayed in
the
dropdown.

(I hope this makes sense.)