4 Replies Latest reply: Feb 22, 2016 8:13 AM by Sunny Talwar RSS

    search from a range

      Hi

      I have a lookup table like this. say crosstab:

       

      CircleLowHighPF
      AP110.5
      AP11201
      AP2199992
      BR1300
      BR3199991

       

      Another table has following data:

      CircleProductCount
      APAAA40
      APBBB101
      BRAAA10

       

       

      I need to put PF in table 2, based on looking at table2. count between Low and High value in table A.

      Tried IntervalMatch. But as table A has Circle as a parameter, does not seem to work. (Maybe I don't know how to use).

       

      Any inputs to above question will be appreciated.