In other words I have a large table and have data in a column that is not linked to another table but I want to still lookup the data and return a value from another table. A lot like a true excel vlookup.
They are related, but not linked, i have a table that pulls data in from may tables. Based on the info pulled in i will need to look up a value to display. This seems probably to complex but i thought I would ask. So currently the Lookup Cell type asks for a table to look up, i thought it could ask what Column in the Current Table, then what table and then what to return.