# How to VLOOKUP?

**URL:** <https://forums.knack.com/t/how-to-vlookup/11214>\
**Category:** Get Answers\
**Created:** [September 24, 2021, 11:45pm UTC](https://forums.knack.com/t/how-to-vlookup/11214 "2021-09-24T23:45:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![knckusr](https://avatars.discourse-cdn.com/v4/letter/k/e95f7d/32.png) [@knckusr](https://forums.knack.com/u/knckusr)\
**Post date:** [September 24, 2021, 11:45pm UTC](https://forums.knack.com/t/how-to-vlookup/11214/1 "2021-09-24T23:45:11Z")

</div>

Hi,

I have the following 3 objects (Routes, Products & Quotes):

 ![2021-09-25_01h41_33](https://us1.discourse-cdn.com/flex020/uploads/knack/original/1X/6a293e4bbfe7212f2a9b5996a6fcd3d5e3ea727e.png)

When someone enters a quote for a Product, i would just like to disclose on DeliveryPlace Field the possible DeliveryPlaces, and to automatically calculate the Delivery Cost for that Product to the Selected Destination, without disclosing the Origin (LoadingAddress) of the product…

How could we implement it?

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![CarlHolmes](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/carlholmes/32/2814_2.png) [@CarlHolmes](https://forums.knack.com/u/CarlHolmes)\
**Post date:** [September 25, 2021, 6:49am UTC](https://forums.knack.com/t/how-to-vlookup/11214/2 "2021-09-25T06:49:19Z")

</div>

Depends on your table relationships but you should be able to use a text formula field or just use the value from a connected table in a view.

---

<div class="post-metadata">

**Author:** ![knckusr](https://avatars.discourse-cdn.com/v4/letter/k/e95f7d/32.png) [@knckusr](https://forums.knack.com/u/knckusr)\
**Post date:** [September 25, 2021, 7:24am UTC](https://forums.knack.com/t/how-to-vlookup/11214/3 "2021-09-25T07:24:10Z")

</div>

I’ve been able to set it up by following the instructions of [Feature Highlight: Dependent Dropdowns on Forms - Knack Blog](https://www.knack.com/blog/feature-highlight-dependent-dropdowns-on-forms)

---

<div class="post-metadata">

**Author:** ![SteveV](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stevev/32/895_2.png) [@SteveV](https://forums.knack.com/u/SteveV)\
**Post date:** [September 25, 2021, 4:06pm UTC](https://forums.knack.com/t/how-to-vlookup/11214/4 "2021-09-25T16:06:38Z")

</div>

Use Integromat. Quite simply, it’s magic.

> **['Programming' Knack with Integromat (part 1)](https://www.onlinedatabase.expert/post/programming-knack-with-integromat-part-1)**
>
> If you're like me, you've been drawn to No-Code and / or Low-Code databases because you aren't keen on writing loads of code - especially not using 'real' programming languages like JavaScript and you value your time! In this series, I'm going to be...

---

<div class="post-metadata">

**Author:** ![JulianKirkness](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/juliankirkness/32/770_2.png) [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\
**Post date:** [September 27, 2021, 8:12am UTC](https://forums.knack.com/t/how-to-vlookup/11214/5 "2021-09-27T08:12:52Z")

</div>

@SteveV - thanks for signposting my post here - I was going to do the same but had a busy weekend!

This would be quite simple to do in [Integromat](https://www.integromat.com/?pc=kirkness) - just search for a Routes record with matching LoadingAddress and DeliveryPlace, find the value and update the quote. The only potential issue is that this would not happen visibly in the UI as you enter the record - unless you were to use the technique I describe in the following article to return a response to Knack:

> **[Knack and Integromat - Waiting for a response](https://www.onlinedatabase.expert/post/knack-and-integromat-waiting-for-a-response)**
>
> I've written a number of posts here about using Integromat as a 'programming' tool for Knack database applications. My motivation has been to offer Knack users an alternative to writing JQuery / Javascript when logic is required which goes beyond the...