5 Replies Latest reply on Oct 14, 2019 7:17 AM by Ken Flerlage

    Vlookup range value from Table2 and insert Column with range value in Table1

    Chirayu Amin

      I have Table1 with certain values in one column with multiple rows and it falls in the range defined by two-column(Imei range start and Imei range end in Table2. Need to do vlook up of which range value it belongs to and inserts corresponding row values of other matched columns

       

      Table 1

       

      IMEI
      11111111
      11111117
      11111138
      11111116
      11111123
      11111135

       

       

      Table2

       

       

      DeviceRSRPSINRIMEI Range StartIMEI Range End
      Motorola-361011111100111111112
      Samsung-381211111113111111117
      Samsung S44-431011111118111111128
      LG-641011111129111111143

       


      Table1 Final After calculated Field

       

       

      IMEIDeviceRSRPSINR
      11111111Motorola-3610
      11111117Samsung-3812
      11111138LG-6410