3 Replies Latest reply: Jul 22, 2018 11:06 AM by Jonathan Dienst RSS

    How to do lookup() in script load with no exact match

    P Schweg

      Hi Community,

       

      Hope you can help me with next:

      I have a facts table with unique numbers, points and a rent value.

      Based on that I joined a table to get max rent per point (see bottom left), that's OK:)


      BUT, now I would like to determine the other way: max points based on given rent.

      My problem is that the rent has not an exact match with the joined table.


      Can you help me to solve this?

      In excel the solution is a Vlookup function with TRUE as 4th argument.

       

       

      Max rent per point.PNGPreview.PNG

       

      Thanks in advance! Gr Pascal