3 Replies Latest reply: Oct 30, 2014 11:38 AM by Ishaq Baig RSS

    How to match on two ranges

      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.