# Lookup using multiple columns

**URL:** https://community.glideapps.com/t/lookup-using-multiple-columns/73787
**Category:** Ask for Help
**Created:** [May 31, 2024, 11:45pm UTC](https://community.glideapps.com/t/lookup-using-multiple-columns/73787 "2024-05-31T23:45:07Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![dtks](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dtks](https://community.glideapps.com/u/dtks)
#### Post date: [May 31, 2024, 11:45pm UTC](https://community.glideapps.com/t/lookup-using-multiple-columns/73787/1 "2024-05-31T23:45:07Z")

</div>

Hi there, new to Glide,

I have a “transactions” table here, and based on the Insurer and Policy, I would like to pull the corresponding commission rate from the “insurer and policy” table.

Basically it’s a lookup with multiple columns but I can’t seem to get it to work. Appreciate the help!

This is the insurer and policy table, and you can see that depending on the insurer and policy, commission is different

 ![Screenshot 2024-06-01 at 7.39.55 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08d5a6e8fe22371ea126a50f78650b9b364c8e75.png)

This is the transactions table where I want to pull in the commission rate based on the 2 columns

 ![Screenshot 2024-06-01 at 7.40.02 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb7a72a6c0008d035d3535a18a513f69610da863.png)

Also, as an aside, what is little blue icon thing on my clients table and what does it do?

Thank you!

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [May 31, 2024, 11:59pm UTC](https://community.glideapps.com/t/lookup-using-multiple-columns/73787/2 "2024-05-31T23:59:29Z")

</div>

- In your Transactions table, create a Query column that targets the Insurer & Policy table, and apply the following filters:  
– Insurer is This row-\>Insurer  
– Policy Type is This row-\>Policy Type
- Add a Single Value column that takes the first commission rate from the Query.

The blue icon on your Clients table indicates that it is configured as your User Profiles table.

> **[User Profiles | Glide Docs](https://www.glideapps.com/docs/essentials/security-and-user-data/user-profiles)**
>
> Define, store, and use data on your app's users.

---

<div class="post-metadata">

### Author: ![dtks](https://avatars.discourse-cdn.com/v4/letter/d/7bcc69/32.png) [@dtks](https://community.glideapps.com/u/dtks)
#### Post date: [June 1, 2024, 12:08am UTC](https://community.glideapps.com/t/lookup-using-multiple-columns/73787/3 "2024-06-01T00:08:58Z")

</div>

Hi @Darren_Murphy, THANK YOU SO MUCH! I was banging my head at 2am for this.

---

<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: [June 8, 2024, 12:09am UTC](https://community.glideapps.com/t/lookup-using-multiple-columns/73787/4 "2024-06-08T00:09:06Z")

</div>

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