# Reference other columns after using the @reference

**URL:** <https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206>\
**Category:** Ask the Community\
**Created:** [February 22, 2018, 5:19pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206 "2018-02-22T17:19:26Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Al\_Chen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen/32/7293_2.png) [@Al\_Chen](https://connect.superhuman.com/u/Al_Chen)\
**Post date:** [February 22, 2018, 5:19pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/1 "2018-02-22T17:19:26Z")

</div>

This question came up after I saw @nigel’s post in [this thread](https://connect.superhuman.com/t/concatenating-rich-text/167/2):

> [@Concatenating Rich Text](https://connect.superhuman.com/t/concatenating-rich-text/167/2):
>
> It’s also good practice to avoid Nth where possible. If you have a well known row that you want to refer to you can reference the row and pick values from it by using an @reference.

How you would reference other columns in the table that are _not_ the display column once you’ve set the @reference? If I want to get the value in the `Link` column below I was thinking you could do something like `@More Text.Link`. My workaround has been adding in an ID column and using the `FILTER()` formula like so:

![16%20PM](https://global.discourse-cdn.com/coda1/original/1X/85c2dbdf094b3cecec5ab9bf3d7d91121374d1d0.png)

---

<div class="post-metadata">

**Author:** ![chris\_homburger](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/chris_homburger/32/6673_2.png) [@chris\_homburger](https://connect.superhuman.com/u/chris_homburger)\
**Post date:** [February 23, 2018, 12:03am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/2 "2018-02-23T00:03:47Z")

</div>

@Al_Chen I came here just now with that exact question!

If I have a Table of Contents table as a header with some metadata, how can I reference that metadata in the canvas without using `=[Table of Contents].filter(....).data` ?

My workaround is making a control item instead of tagging, then setting it to whatever value of the table I am looking to view.

---

<div class="post-metadata">

**Author:** ![nathan](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nathan/32/5616_2.png) [@nathan](https://connect.superhuman.com/u/nathan)\
**Post date:** [February 23, 2018, 1:20am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/3 "2018-02-23T01:20:57Z")

</div>

Have you tried the [Lookup() formula](https://help.coda.io/formulas/using-lookups#how-to-use-the-lookup-formula)?

@Al_Chen, in your example you could write either of these formulas depending on your syntax preference:  
=Lookup(myTable,ID,2).Link  
=myTable.Lookup(ID,2).Link

---

<div class="post-metadata">

**Author:** ![nathan](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/nathan/32/5616_2.png) [@nathan](https://connect.superhuman.com/u/nathan)\
**Post date:** [February 23, 2018, 1:23am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/4 "2018-02-23T01:23:29Z")

</div>

You can also write =@Some Text.Link – key is to write the = before the @, then you’re able to dereference to pick a different column.

---

<div class="post-metadata">

**Author:** ![evan](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/evan/32/5534_2.png) [@evan](https://connect.superhuman.com/u/evan)\
**Post date:** [February 23, 2018, 1:28am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/5 "2018-02-23T01:28:11Z")

</div>

> [@Al\_Chen](#):
>
> How you would reference other columns in the table that are not the display column once you’ve set the @reference? If I want to get the value in the Link column below I was thinking you could do something like @More Text.Link. My workaround has been adding in an ID column and using the FILTER() formula like so:

Great question! There’s actually a (admittedly hidden) way to do this in the canvas WITHOUT a filter 😱

In the canvas, try `=@More Text.Link`. The `=` makes all the difference! It’s similar to projections inside of a table - specifically if you have a column of references to another Table (or a Lookup formatted column), you can project values from that Table using `=[Reference Column].[Column from the Table the reference is from]`

How does that work for y’all? cc @chris_homburger

---

<div class="post-metadata">

**Author:** ![Al\_Chen](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen/32/7293_2.png) [@Al\_Chen](https://connect.superhuman.com/u/Al_Chen)\
**Post date:** [February 23, 2018, 2:33am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/6 "2018-02-23T02:33:07Z")

</div>

@nathan The `Lookup()` formula works but that still requires you to know the ID of the row. The question I had was in reference to @nigel’s statement that you can use the @reference to pinpoint the row and then retrieve another column from that specific row. Looks like both you and @evan found the solution which is using the equals sign before doing the @reference 👌

@chris_homburger How does your workaround work with the control item? Could you post a screenshot with formula?

The concept of using the @reference to pinpoint a row and then pulling in the column reference could be an anti-pattern compared to a `VLOOKUP()` in Excel. When you have a long list of IDs/unique names and you need to pull in data for a summary table, you would type the handful of IDs/names in the summary table and then run `VLOOKUP()` to find associated data. With the Coda @reference used in the canvas, it feels like the user needs to be trained to disregard the ID and think about the _unique value_ (in my case, thinking about “More Text”) as the lookup value. This means the first column–or whatever the “display” column is–should be truly unique be it a list of your friends’ names, team names in your company, etc. Then the user should be conditioned to reference the unique name in the formula vs. the row ID.

---

<div class="post-metadata">

**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\
**Post date:** [June 3, 2018, 8:09am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/7 "2018-06-03T08:09:24Z")

</div>

Not sure if I am on the right place to ask 😉 how can I now do a simple lookup for additional fields (like vlookup) on another table?

tried this one, but it’s not working:  
filter(Soll=Kontenplan.Bezeichnung).Gliederung  
whereas Soll and Bezeichnung are both keys, Gliederung is a text in the linked table

Thanks for your opinion.

Best  
Thomas

---

<div class="post-metadata">

**Author:** ![Al\_Chen\_Coda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen_coda/32/5588_2.png) [@Al\_Chen\_Coda](https://connect.superhuman.com/u/Al_Chen_Coda)\
**Post date:** [June 3, 2018, 6:41pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/8 "2018-06-03T18:41:47Z")

</div>

Hey @Thomas_Schulz, if you try `filter(Soll=Bezeichnung).Gliederung`, does the formula work? Looks like “Bezeichnung” is the name of the table you are trying to output the values from the linked table. If you remove it from the formula it should work.

---

<div class="post-metadata">

**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\
**Post date:** [June 4, 2018, 11:03am UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/9 "2018-06-04T11:03:31Z")

</div>

I tried like this:  
filter(Soll=Kontenplan.Bezeichnung).Kontenplan.Gliederung

Because “Bezeichnung” is the linking colum to the table “Kontenplan”. Just adding Bezeichnung does not work

---

<div class="post-metadata">

**Author:** ![Al\_Chen\_Coda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen_coda/32/5588_2.png) [@Al\_Chen\_Coda](https://connect.superhuman.com/u/Al_Chen_Coda)\
**Post date:** [June 4, 2018, 3:53pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/10 "2018-06-04T15:53:28Z")

</div>

Gotcha, you don’t need to reference the table in the filter, just the column names. Do you mind taking a screenshot of your tables, or sharing your doc with [support@coda.io](mailto:support@coda.io)? It will be easier to debug this issue for you!

---

<div class="post-metadata">

**Author:** ![Thomas\_Schulz](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/thomas_schulz/32/1035_2.png) [@Thomas\_Schulz](https://connect.superhuman.com/u/Thomas_Schulz)\
**Post date:** [June 4, 2018, 4:14pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/11 "2018-06-04T16:14:57Z")

</div>

you have already access 🙂  
it’s in here [https://coda.io/d/beeq-GmbH\_dWOajJrCXL3/Bilanz-neu\_suo-h#\_luooz](https://coda.io/d/beeq-GmbH_dWOajJrCXL3/Bilanz-neu_suo-h#_luooz)

---

<div class="post-metadata">

**Author:** ![Al\_Chen\_Coda](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/al_chen_coda/32/5588_2.png) [@Al\_Chen\_Coda](https://connect.superhuman.com/u/Al_Chen_Coda)\
**Post date:** [June 4, 2018, 4:46pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/12 "2018-06-04T16:46:14Z")

</div>

Take a look at the formula! I moved the “Kontenplan” table to the outside of the formula and applied the filter to it. What’s tricky is that the “Soll” column is a Lookup to another table, so I had to apply the `ToText()` formula to “Soll” to get just the text for this column. Here’s the final formula:

`Kontenplan.filter(Bezeichnung=Soll.ToText()).Gliederung`

---

<div class="post-metadata">

**Author:** ![Marcelo\_Cardoso](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/marcelo_cardoso/32/45663_2.png) [@Marcelo\_Cardoso](https://connect.superhuman.com/u/Marcelo_Cardoso)\
**Post date:** [February 20, 2025, 8:06pm UTC](https://connect.superhuman.com/t/reference-other-columns-after-using-the-reference/206/13 "2025-02-20T20:06:33Z")

</div>

Considering that my table should be a variable, how could I reference it? In the first example, see that Al\_Chen calls the table `myTable`, but if I had several tables and wanted the query to be dynamic, how would I do it?
