# Problem with Lookup Function Autofilling a column

**URL:** <https://connect.superhuman.com/t/problem-with-lookup-function-autofilling-a-column/6072>\
**Category:** Ask the Community\
**Created:** [February 1, 2019, 4:07pm UTC](https://connect.superhuman.com/t/problem-with-lookup-function-autofilling-a-column/6072 "2019-02-01T16:07:52Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Scott\_Weir](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/scott_weir/32/10111_2.png) [@Scott\_Weir](https://connect.superhuman.com/u/Scott_Weir)\
**Post date:** [February 1, 2019, 4:07pm UTC](https://connect.superhuman.com/t/problem-with-lookup-function-autofilling-a-column/6072/1 "2019-02-01T16:07:53Z")

</div>

I want autofill a column when it matches another column from another table. Full explanation in the image attached below! Would greatly appreciate the help!

 ![CODA%20QUESTION](https://global.discourse-cdn.com/coda1/original/2X/0/0899da2f74a3f6aea4c2724f0e210b43136d4ea9.jpeg)

---

<div class="post-metadata">

**Author:** ![Ander](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/ander/32/9134_2.png) [@Ander](https://connect.superhuman.com/u/Ander)\
**Post date:** [February 1, 2019, 4:36pm UTC](https://connect.superhuman.com/t/problem-with-lookup-function-autofilling-a-column/6072/2 "2019-02-01T16:36:55Z")

</div>

@Scott_Weir

1/2  
 ![students-2_2019-02-01_1030](https://global.discourse-cdn.com/coda1/original/2X/c/c7d8e0befb33c0cf0084f7c9be56326546cb56bf.png)

* * *

2/2  
 ![students-1_2019-02-01_1031](https://global.discourse-cdn.com/coda1/original/2X/d/df2e3d98927b3a9838d2fc0640ff306714947427.png)
