How can I select a specific value between two dates based on other criteria

Hi There,

How can you select values in a table between two dates, that also meet other criteria?

In the table I have the columns "Start date", "Role", "Ward" and "Activity".

I wish to find the lowest "Start date" larger than 'x' but less than'x+1' (interger day) which also has a "Role" equal to 'a', "Ward" equal to 'b' and "Activity" equal to 'c'

The values for 'x', 'a', 'b', and 'c' are all user defined in another sheet via dropdown lists, while the table is linked to a SQL database.

Any help would be great.

Hey There,

Simplified file attached (hopefully work as first timer) - Anyway I am trying to set B6 (in red) to the lowest startdatetime based on the following criteria for the Table in Sheet2:

Ward = A3
Role = B3
Activity = C3
A5 < Startdatetime < A5+1

Thanks

Haseeb A

Your formula returns the first value in the 'StartDateTime' column, not the first value in the column greater than cell A5 - the attached spreadsheet was a simplified version of the spreadsheet I am working in - there are multiple dates and all criteria need to be included.

Have tried the example below which worked fine - thanks heaps for the help.

=MOD(MIN(IF((Sheet2!$A$2:$A$494=A$3)*(Sheet2!$B$2:$B$494=B$3)*(Sheet2!$D$2:$D$494>A$5),IF(Sheet2!$C$2:$C$494=$C$3,Sheet2!$D$2:$D$494))),1)