What's the equivalent of a VLOOKUP in Knack?
I have a table of numbers that correspond to names, e.g.
Area Number Area Name
When creating records, it is easiest to use the number, but on one of my pages, I want to have a column of the numbers and then another column that looks up and returns the name that corresponds to the number. In Excel or Google Sheets, this is easily done with VLOOKUP. Does anyone know how to do this in Knack?
Thanks for your help,