# Help with Lookup Column type
**URL:** https://community.glideapps.com/t/help-with-lookup-column-type/71584
**Category:** Ask for Help
**Created:** [March 11, 2024, 10:17am UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584 "2024-03-11T10:17:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [March 11, 2024, 10:17am UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584/1 "2024-03-11T10:17:22Z")
Hey Guys,
When I do lookup for a filed from particular column. It lists all the values present in the particular Column. Is there a way I can only get the single value from the row it is selected?
EX: I have a table A which has two columns “Brand Name” , “POC Name” “Owner”
In Table B I have a choice column, which lists all the “Brand Names” from Table A —\> when I select one Brand Name —\> It should auto populate the "POC Name " and “Owner” from Table A based on selected value in the dropdown.
Can someone please guide me as to how can we do this?
I was using airtable where Lookup can be limited to particular column value. Now sure how to do it in glide db
Regards,
Dilip
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [March 11, 2024, 11:10am UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584/2 "2024-03-11T11:10:19Z")
I did it using combination of relation column and Lookup from Relation column.
is this ideal way to do it?
Regards,
Dilip
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [March 11, 2024, 1:16pm UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584/3 "2024-03-11T13:16:21Z")
Yes, that’s the correct way to do it. Your original way targets the whole column, the new way “filters” it through the relation, so it should be the correct value you’re looking for.
---
### Author:  [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)
#### Post date: [March 12, 2024, 3:10am UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584/4 "2024-03-12T03:10:49Z")
Thank you for the reply 🙂
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 19, 2024, 3:10am UTC](https://community.glideapps.com/t/help-with-lookup-column-type/71584/5 "2024-03-19T03:10:59Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.