Can you define your lookup array based on a certain citeria?

xceltime_ss

New member
Joined
Apr 23, 2020
Messages
2
Reaction score
0
Points
0
Excel Version(s)
office 365
Hello,
I have attached a sample of my data.
For each time a card number is expired, i need to look for the card number in the consequent transactions to see if the same card number was processed within 3 days time. I need to look-up to return the new status.

Basically, I need to define my look-up array based on whether the date, if the transaction date is within three days from the lookup value's date.
 

Attachments

  • Array.xlsx
    11.1 KB · Views: 4
In a spare column on row 2:
Code:
=A2-MAXIFS($A$2:$A$30,$C$2:$C$30,"Expired",$D$2:$D$30,D2)
will return a small number (stop Excel from trying to format it as a date) if there has been an expiry (it's actually the number of days since the latest expiry). You can do something with that?
 
Back
Top