Hi All!
I have 2 tables:
| ID | Type | Value |
| 123 | A | $100 |
| 456 | A | $3,000 |
| 879 | B | $4,000 |
| 234 | B | $7,000 |
| Type | Sequence | Value |
| A | 1 | $1,000 |
| A | 2 | $4,000 |
| B | 1 | $1,000 |
| B | 2 | $6,000 |
| B | 3 | $10,000 |
For each ID, I need to find out which Type and Sequence it should be based on the second table. For example, ID 123 should be in Sequence 2 of Type A, ID 879 should be in Sequence 2 of Type B. I'm thinking using the function, Interval Match, but i'm not too sure.
