# Does anyone know how to make a vlookup \[May 12\]

**URL:** https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436
**Category:** Discord-Discussions
**Created:** [November 3, 2022, 9:36am UTC](https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436 "2022-11-03T09:36:59Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 9:36am UTC](https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436/1 "2022-11-03T09:36:59Z")

</div>

> 🙋‍♂️ **CaptainKranch** _asked_

## does anyone know how to make a vlookup on another table? I know it has an option to link to another table and then use the lookup function but if I have multiple records do I have to enter manually each link? My work around was to use the API to bulk update the link column but when I use the swagger API it doesn’t shows the link column, am I doing something wrong or does anyone knows how to do a VLOOKUP function with another table?

![image0](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/8c06747c064041e39332a29ddb6de58bf8da5003.png)

 ![image1](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/54aa4b12d6413fb319a0e99901d4f6968ee1bf29.png)

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 9:37am UTC](https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436/2 "2022-11-03T09:37:00Z")

</div>

> 💁 **o1lab** _replied_

#### sorry, vlookup isnt available

#

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 9:37am UTC](https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436/3 "2022-11-03T09:37:01Z")

</div>

> 🙋‍♂️ **CaptainKranch** _replied_

#### Ok!! thanks for the help

#

---

<div class="post-metadata">

### Author: ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)
#### Post date: [November 3, 2022, 9:37am UTC](https://community.nocodb.com/t/does-anyone-know-how-to-make-a-vlookup-may-12/436/4 "2022-11-03T09:37:02Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/971498118359158805)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)