Coda's equivalent to Excel's Vlookup

Hi friends,

I am coming from Excel and searched for a possibility to Link to tables like Vlookup in Excel. I got a create answer from Betty Huang [Coda.io] and think it is worth to share!

The sample task is a ToDo list for team members from different companies.
Step One - Create a table with company names. You will use this when assigning companies to employees through the People lookup table.
image
Step Two - Create a table with employees, and the companies they work for. You can format the Person column as “People” if you want it to be associated with their gmail accounts, or just as “Text” if a simple name is fine. You can format the Company column as “Lookup from Table” to pull data from the Companies table created in step one.
image
Step Three - Create a task list, formatting the assignee column as “Lookup from table,” so you can use the data from the People table created in step two. If you want to view the company the assignee works for, set the formula of the third column to be =Assignee.Company.
image
This was so easy and I love coda.io more and more.
Here is also a link to the shown project: Coda | A new doc for teams.

8 Likes

Thanks for posting @Thomas_Hebes! Lookup from Table is definitely one of the more powerful features in Coda that gives you similar functionality as VLOOKUP and then some!

1 Like

Seriously thank you! This is the example I was looking for. I was racking my head trying to get the lookup formula to work following the Lookup guide but this solution was so easy I just laughed after it just worked. Going to take a little bit to retrain my brain away from thinking the vlookup format is the “easy” way.

1 Like

I think the best way to visualise the lookup referencing is to hover over the referenced field and see all the other field that popup. Those are the ones that can be pulled into being diplayed in that table. So cool!

1 Like

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