I am really enjoying Coda so far, but seriously struggling with Lookups. I am trying to do the equivalent of a vLookup between two tables. I’ve ready everything I can find in forums, but haven’t cracked the code yet.

Screenshot below:

In the Purchasing.Category field, I would like a formula that will find a row specific value in Categories.Report based on a match between Purchasing.ProductlineDescription and Categories.Ops. I would like to do the same with Purchasing.SuperCategory based on Purchasing.ProductlineDescription and Categories.Ops.

With a vlookup formula, it would look something like this =vlookup(c2,categories,2,false), with categories being a named range.

I do a lot of this, so it will be very helpful. Thanks in advance.