Hello,

I am using the following formula to lookup a value in column A.

=INDEX(ACCOUNTS!A:A,MATCH(LARGE(ACCOUNTS!$H$4:$H$100,1),ACCOUNTS!H:H,0))

Is is possible to return the first result if a date in the same row in column B is no older than 7 days?

For example, it finds the first largest amount, but the date in column B of the same row is older than 7 days, so it will go on to the next largest sum.

Sounds complicated, not sure if it can be done.

But thanks for any help.

Nick