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?

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.