The formula reference recommends using `Filter()`

instead of `Lookup()`

but they work somewhat similarly. This should get you where you’re going:

```
[Jan] * (
1 +
[Growth Rates].Filter(
currentValue.Category = thisRow.Category
).First().Rate
)
```

You can have this all on one line, or broken up like I’ve done here for clarity (makes no difference).

- This takes January and multiplies it by 1 + …
- The growth rates table, filtered just to items where the category matches.
- You don’t have to explicitly write out
`currentValue`

and `thisRow`

, but it can help. The alternative to writing them out is to type `Category`

and then hover on the suggested options - Coda will tell you which table’s “Category” column each one belongs to. “CurrentValue” in Coda means the current row in Growth Rates table being considered by the filter, and “thisRow” means the row in P&L table where this formula lives.
- Then we take the first result, just in case you had multiple “Revenue” rows in Growth Rates (things would get weird if we had >1 result)
- Then once we have our row selected, that’s when we tell it we’re interested in the Rate column

Edit to add: Coda gives you the option of dot chaining instead of bracket wrapping. More details here. Essentially, to grab the first item, you can either do the Excel-style `First(a list of items)`

or the more chronological-and-therefore-intuitive-to-many `(a list of items).First()`

If you wanted to re-write the above fully wrapped it would be more like

```
[Jan] * (
1 +
First(
Filter(
[Growth Rates],
currentValue.Category = thisRow.Category
)
).Rate
)
```

But personally I think you’ll have an easier time if you get into the dot chaining headspace, because it matches Coda structures like `thisRow.aColumn.anItemInThatColumn.ThatItemsProperties`