I’m looking to implement the conventional VLookup (from MS EXCEL) into Coda and haven’t been successful. My Problem statement is as below:
Table 1 has 2 columns EmployeeID, Manager
Table 2 has multiple columns and EmployeeID is one of them. I want to add a column to this table and populate the Manager using the formula.
I have tried solutions at Pulling Data from another Table and Lookup from other table - #4 by Daniel_Stieber but it doesn’t work for me my list contains 1000+ rows and manually selecting the values from dropdown and then pull data is a strenuous task. Looking for a quick response to finish my POC due this Wed morning