Equivalent of VLOOKUP in Knack?


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

1 Simpson

2 Ross

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,


Hi Jim,

I recently asked a similar question involving "vlookup" and Nic was kind enough to give us a solution:


Hope this helps.