I have fooled with this thing for over a day and am very frustrated. On the attached workbook I have two sheets the first sheet called calendar starts in B2 with the formula Today() the next cell over has the formula b2+1 making it the next day and so forth accross the row. The other sheet is a table contaiing events. What I want to have happen is that under b2 or c2 or d2 lookup in the events table and list the events that match the date above it. Everytime I try to set up a lookup function and use the row 2 reference as a value it sums it and does not handle it as a date. Can anyone help me with this?