# Finding a value in a table based on row and column input

**URL:** <https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428>\
**Category:** Ask for Help\
**Created:** [April 11, 2023, 9:28pm UTC](https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428 "2023-04-11T21:28:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SEAPA\_App](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seapa_app/32/55860_2.png) [@SEAPA\_App](https://community.glideapps.com/u/SEAPA_App)\
**Post date:** [April 11, 2023, 9:28pm UTC](https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428/1 "2023-04-11T21:28:04Z")

</div>

Hi, new to Glide. I’m building an application that will do some calculations based on user input. Specifically, the user will select an altitude and a temperature. I’d like the application to then lookup the associated value from a table. Here’s the data table layout:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/f/5f8da26b06c9754ca6888723e68f7e7d0ed32070.png)

So given an altitude of 5,000 and a temperature of 25, the resultant values would be MaxGW = 9,500, Max Q = 50, and the HOGE = 43.5

The orginal data layout is:

 ![origGrid](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8ef8ece530a8ba5609cf653967d7560983d086a1.png)

I’m up for reformatting/adjusting the data as necessary, just what the most effective and efficient method might be.

Thanks in advance!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 12, 2023, 12:37am UTC](https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428/2 "2023-04-12T00:37:31Z")

</div>

> [@SEAPA\_App](#):
>
> I’d like the application to then lookup the associated value from a table.

You can create a template column that will join the altitude and temperature your user chose, and a template column that joins the altitude and temperature in the “source” table.

Create a relation from the first template column to the second template column, next use a lookup to pull back all values needed to show your user.

---

<div class="post-metadata">

**Author:** ![SEAPA\_App](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/seapa_app/32/55860_2.png) [@SEAPA\_App](https://community.glideapps.com/u/SEAPA_App)\
**Post date:** [April 12, 2023, 1:44am UTC](https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428/3 "2023-04-12T01:44:09Z")

</div>

Fantastic, works like a champ! Thanks very much!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [April 13, 2023, 1:44am UTC](https://community.glideapps.com/t/finding-a-value-in-a-table-based-on-row-and-column-input/60428/4 "2023-04-13T01:44:20Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.