Mason Green
New Member
- Joined
- Sep 24, 2018
- Messages
- 1
Hey guys, I have an issue I can't seem to figure out how to accomplish. I have two tables of transaction data. I want be able to look up if a certain transaction on table 1 (We'll Transaction A) is on table 2 BUT only if it occurs within 30 days of transaction 1 AND is within +-$500 of Transaction A.
Example: Transaction A on Table 1 = 14,500 and occurred on 2/1/2011. I want to know if there is a transaction between 14,000 and 15,000 that occurred between 2/1/2011 and 3/1/2011.
I know how do something similar using a Database function like DGET(), but that only works for a single transaction. I need a formula I can drag down for each of my transactions on Table 1.
Hopefully that makes sense.
Thanks,
Example: Transaction A on Table 1 = 14,500 and occurred on 2/1/2011. I want to know if there is a transaction between 14,000 and 15,000 that occurred between 2/1/2011 and 3/1/2011.
I know how do something similar using a Database function like DGET(), but that only works for a single transaction. I need a formula I can drag down for each of my transactions on Table 1.
Hopefully that makes sense.
Thanks,