4 Replies Latest reply: May 15, 2014 10:15 AM by lcwalker _ RSS

    Monarch 10.5 Value based on range

    lcwalker _

      Good afternoon.  I have a price file with values from $100 all the way to $10,000.  I also have a spreadsheet with value ranges, for example 100-199, 200-499, etc.  Each of these value ranges has an identifier associated with it.  Is there a way in Monarch to compare the value in the price file with the value range and provide the associated identifier?