Convert calculated field into text

I have a formula that calculates a numerical value, and based on the value I want it to go to the lookup table and then display the text value in my current table. I’m struggling to do this, even using the videos available around lookup tables since it’s a calculated field. Any help?

In excel, it’s an easy vlookup, but its not working at all on here coda :frowning:

Its hard to understand what its not working, could be a missing totext() somewhere or a problem in the overall logic.

Could a prepare a little demo doc and share it here?