I have forgotten if you are scripting or using keyword tests. If you need this for keyword I can work out an example.
For scripting, you can use the example here with an addition for your criteria something like this. No warranties on my syntax or logic 🙂
https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/drivers.html
{
while (!Driver.EOF() AND !((MyDate = ExcelDate) AND (MyCheckAmount = ExcelAmount))
Driver.Next();
//while these are both true, keep looping
}
// see if you stopped because of data found or data done
if ((MyDate = ExcelDate) AND (MyCheckAmount = ExcelAmount))
then get the rest of the row data
else
log message "data not in Excel"
DDT.CloseDriver(Driver.Name);