Hello Coda Community! I’m trying to adjust from using Vlookups in excel to the formulas in Coda. I’m trying to accomplish something similar but can’t for the life of me get the Lookup formula to work. Here’s what I’m trying to do:

Solution and Complexity live on this table:

I need to pull the “complexity” for the Solution type into my summary table by referencing the Solution column, looking for that solution in the master data table and pulling the complexity score into column “S1 Score” column. And then be able to “drag” that formula down so that it will function just like a vlookup and find the solution in the master table and pull the complexity for each.

Hi Samuel - I’m sure this is absolutely butchered. and not sure it will make sense since I’m just winging it based on my brain wanting it to function like a vlookup