Kay

Try

=IF('CH Milestones'!GM5Sheet1!A$2,"",VLOOKUP('CH Milestones'!GM5,'CH
Milestones'!GL$5:GM$87,2,FALSE))

John


"Kay" wrote:

I want to automatically produce a list of all events that will occur between
two given dates.

I am using VLOOKUP to search the column which has the date for each event. I
want to return the names of all the events that occur before the user-defined
dates.

My formula looks like this:

=IF('CH Milestones'!GM5<Sheet1!A$2,VLOOKUP('CH Milestones'!GM5,'CH
Milestones'!GL$5:GM$87,2,TRUE),"")

GM is the column with the dates.
GL is the column with the event names.
A2 has a user-defined date entered into it.

(In the above formula I was only looking for dates before A2; ultimately I
want only those between two dates.)

Many thanks...