Get corresponding values from island table

[fionna51]

Please see attached simple application, I just want to get corresponding payment for each entity based on rate. It's kind like after monthly review, each entity has a rate, and in reference table each rate will have a payment. I want to show the payment for each entity.

It's just a look up, however I got some issue, if I use max, it will show max payment to all entities.

Thanks in advance.

[petter]

This works - it looks a bit ugly though:

Pick(

Match( Rate ,

$(=Chr(39)&Concat(Num(mRate,'0.0'),Chr(39)&','&Chr(39),mRate)&Chr(39) ) )

,$(=Concat(Pay,',',mRate))

)