# How to create and use a Lookup field **URL:** \ **Category:** Forum Leader tips\ **Tags:** community-content, forum-leader-tip, agentic-work-management, tables\ **Created:** [28 October 2026 14:53 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248 "2026-10-28T14:53:31Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\ **Post date:** [28 October 2026 14:53 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/1 "2026-10-28T14:53:31Z")
Lookup fields are a new Asana feature that come as part of the new Tables functionality. Here’s how to create a lookup field and how they work: **STEP 1:** A lookup field pulls values from a particular field (column) in a Table. Here I have a Customer table and I created a field called Address: ![image](https://us1.discourse-cdn.com/asana/original/4X/5/7/e/57e8c77cc63dda0906e487e844616f9157bfdcab.png) **STEP 2:** Once you have your Table, next create a Reference field which references that Table, like this: ![image](https://us1.discourse-cdn.com/asana/original/4X/7/c/f/7cfeb1f924c4a730334426ced5a83516fd60df44.png) **STEP 3:** Once you have a Reference field which maps to that table, next create a Lookup field which references the Reference field from Step 2 and a field in that table, like this: ![image](https://us1.discourse-cdn.com/asana/original/4X/e/d/b/edbf07343235a41dc2c2e978091c9d2137fe5b78.png) **STEP 4:** Now you can add both the Customer Record reference field and the Customer Address lookup field to a project: ![image](https://us1.discourse-cdn.com/asana/original/4X/e/f/3/ef3a150bfe68703b1949de8ec5bdcc543ba70643.png) **USING A REFERENCE AND LOOKUP FIELD:** Now, whenever you select a particular customer using the Customer Record reference field, Asana will automatically look up and fill in the Customer Address lookup field, as shown here: ![Lookup field](https://us1.discourse-cdn.com/asana/original/4X/8/a/4/8a44e7b075a99aee5cc5c5fd2095591c324f97a1.gif) ---
**Author:** ![Tetsuo\_Kawakami](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/tetsuo_kawakami/32/84271_2.png) [@Tetsuo\_Kawakami](https://forum.asana.com/u/Tetsuo_Kawakami)\ **Post date:** [29 October 2026 23:47 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/2 "2026-10-29T23:47:55Z")
@Phil_Seeman Thanks for your work. I found another way to create a lookup field. It might be more intuitive. ![image](https://us1.discourse-cdn.com/asana/original/4X/0/e/e/0eeaf5c08b72d653a100266042df921375fbd642.png) ---
**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\ **Post date:** [30 October 2026 02:07 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/3 "2026-10-30T02:07:21Z")
Good find, @Tetsuo_Kawakami! That would replace Step 3 in my instructions above. (Also, only works if one has the project in List view.) ---
**Author:** ![Tetsuo\_Kawakami](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/tetsuo_kawakami/32/84271_2.png) [@Tetsuo\_Kawakami](https://forum.asana.com/u/Tetsuo_Kawakami)\ **Post date:** [30 October 2026 02:23 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/4 "2026-10-30T02:23:38Z")
@Phil_Seeman On my end, it also works in the table’s list view. ![image](https://us1.discourse-cdn.com/asana/original/4X/a/d/2/ad257a19136aa4e17278061edc8f56a29ffb6da0.png) ---
**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\ **Post date:** [30 October 2026 02:31 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/5 "2026-10-30T02:31:50Z")
Yes, understood and good point. What I meant was that it’s not available in other project views (Board view, etc.). ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [30 October 2026 03:07 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/6 "2026-10-30T03:07:00Z")
Hi @Phil_Seeman , thank you. I was able to access the table following your instructions. By the way, I have a question: I can’t access the column with the name of the table I’m referencing. Am I misunderstanding something? ---
**Author:** ![Phil\_Seeman](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/phil_seeman/32/81525_2.png) [@Phil\_Seeman](https://forum.asana.com/u/Phil_Seeman)\ **Post date:** [30 October 2026 03:44 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/7 "2026-10-30T03:44:04Z")
> [@ka\_nishiyama](#): > > I can’t access the column with the name of the table I’m referencing. You have to create the column (custom field); that’s Step 2 above. Did you do that? ---
**Author:** ![ka\_nishiyama](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/ka_nishiyama/32/292165_2.png) [@ka\_nishiyama](https://forum.asana.com/u/ka_nishiyama)\ **Post date:** [30 October 2026 04:05 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/8 "2026-10-30T04:05:19Z")
I’m doing some testing. Currently in testing status. It seems to be working reasonably well. 1 - Table ![image](https://us1.discourse-cdn.com/asana/original/4X/3/7/7/3779a1863557636c5dfe84c66c00c90cacc747a1.png) 2 - Project ![image](https://us1.discourse-cdn.com/asana/original/4X/f/2/6/f2672b138eac25e0786f2ddd057c377fecfb08b8.png) ![image](https://us1.discourse-cdn.com/asana/original/4X/e/f/e/efec1709b1156d6e02194be08d96e3bcf15dc920.png) ![markup_6436](https://us1.discourse-cdn.com/asana/original/4X/7/8/b/78b883a5b2d239453e6cf7072bddc5bf9fd0148a.png) ![markup_6438](https://us1.discourse-cdn.com/asana/original/4X/c/b/d/cbd1dd92f5d952147d41e4331efcae0856b1c248.png) ---
**Author:** ![Tetsuo\_Kawakami](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/tetsuo_kawakami/32/84271_2.png) [@Tetsuo\_Kawakami](https://forum.asana.com/u/Tetsuo_Kawakami)\ **Post date:** [30 October 2026 13:50 UTC](https://forum.asana.com/t/how-to-create-and-use-a-lookup-field/1160248/9 "2026-10-30T13:50:35Z")
It seems that a lookup field chooses the first match only when a reference field has some elements.