Lookup lowest value in a list for an item for a specific date

Hi,

I've been trying to do the following:

I have a list of machines and i have a long list of services for those machine. Each machine has a contract start date. I want to find the first service (i.e. service entry with the lowest date value) that comes AFTER the contract start date

I tried a couple of ways to no avail, any help is greatly appreciated! See the example attached and thanks for any help!

(also posted on ozgrid http://www.ozgrid.com/forum/showthre...348#post620348)

Ta

J