Hi,

I have a sheet of data.

There are multiple rows with the same record number (coloumn A) where the dates are different (coloumn B).

So, i'd like to lookup where a record number occurs at the same time as a specified date - so two conditions.

Ideally, I would then like to return a value from Coloumn C when this happens.

Thanks!