I know I can match up two tables based upon one range using interval match, however, I have been given a scenario where I need to map the data based on two ranges of data. In this instance we are working with GL data so they want to group their accounts together by certain departments and accounts. So I have table of two ranges (dept 1 - 10, accnt 100 - 150 = expenses, dept 20-30, acct 100 - 150 = variable expenses). I need to run through all my departments and accounts and classify them based upon if the fall with in the two ranges.
You could first match the departments with the department ranges and then match the accounts to their ranges using the department range as key field. See the extended syntax of intervalmatch in the help file.