# Displaying Different Column from Looked Up Row

**URL:** <https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876>\
**Category:** Ask for Help\
**Created:** [May 17, 2021, 3:33pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876 "2021-05-17T15:33:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![CEntrepreneur](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/centrepreneur/32/18572_2.png) [@CEntrepreneur](https://community.glideapps.com/u/CEntrepreneur)\
**Post date:** [May 17, 2021, 3:33pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/1 "2021-05-17T15:33:48Z")

</div>

I have a Debts table where our users can input the different debts/loans they currently have and include things like the Lender Name, Total Amount, Interest Rate, and Monthly Payment.

I have a relation to this table on the User table so that I can do some math for display within the app.

I am trying to display the their debt that has the lowest interest rate, formatted something like:

> Your debt with the lowest interest is LENDER NAME at INTEREST RATE

But I cannot figure out how to get the lowest rate while keeping the relationship with the lender name or other data in that row.

Anyone have any ideas?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 17, 2021, 3:35pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/2 "2021-05-17T15:35:13Z")

</div>

Have you tried a Rollup column with MIN?

---

<div class="post-metadata">

**Author:** ![CEntrepreneur](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/centrepreneur/32/18572_2.png) [@CEntrepreneur](https://community.glideapps.com/u/CEntrepreneur)\
**Post date:** [May 17, 2021, 3:36pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/3 "2021-05-17T15:36:25Z")

</div>

I have. This get’s me the smallest rate which is great but I am not able to reference it in the app because I don’t know which lender is associated with that rate.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [May 17, 2021, 3:37pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/4 "2021-05-17T15:37:14Z")

</div>

Then you can build a template in each sheet that combines the user/interest rate to create a new relation.

---

<div class="post-metadata">

**Author:** ![CEntrepreneur](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/centrepreneur/32/18572_2.png) [@CEntrepreneur](https://community.glideapps.com/u/CEntrepreneur)\
**Post date:** [May 17, 2021, 3:43pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/5 "2021-05-17T15:43:25Z")

</div>

Genius. Just tried it out and it worked perfectly. Thanks!!

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/displaying-different-column-from-looked-up-row/26876/6 "2024-01-17T16:52:09Z")

</div>