Hello everyone,

Hope this post makes sense and someone out there can help

I have a large table in the final tab of my excel book. This table contains data such as Company name, contact details, etc but also a date which I must contact them on (this is nothing sinister, just a curtsy call following a job ).

The problem I am having is that I am running a vlookup on the first tab on a cell referring to todays date. This only brings shows one record which is the first occurrence of this date. This isn't very useful to me

The problems I need solving are:

I would like to be able to vlookup a range of dates (i.e. 7 days before or after todays date) - how do it do this?

I would also like to be able to return multiple results (i.e. if there is more than one company within that date range I would like them to show).


Can anyone help with this? Maybe Vlookups aren't the way to do this?

Any help would be appreciated!

Thanks.