Finding Sequence based off Range

[veldetta]

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.