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.