I think your best alternative is using a mapping table. This can be done with the ApplyMap function.
Read more about ApplyMap here: https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/MappingFunctions/ApplyMap.htm
Here is a YouTube video referring to that Excel function you are trying to do and solving it with ApplyMap and LookUp function.
Hi, yo can add to your points table the min rent for each points to create and interval and use intervalmatch to assign the Points:
Rents: LOAD * inline [ Rent 13 25 90 ]; Points: LOAD * INLINE [ Points, Max Rent 40, 12.21 50, 24.35 60, 35.25 ]; PointInterval: LOAD If(IsNull(Peek([Min Rent])), 99999, Peek([Min Rent])-0.001) as [Max Rent], [Max Rent] as [Min Rent], [Points] resident Points order by Points desc; DROP Table Points; Inner Join IntervalMatch ( Rent ) LOAD [Min Rent], [Max Rent] Resident PointInterval;