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.
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.