# Finding Duplicate Values in Lookup Arrays
**URL:** https://community.glideapps.com/t/finding-duplicate-values-in-lookup-arrays/27585
**Category:** Ask for Help
**Created:** [June 3, 2021, 5:59pm UTC](https://community.glideapps.com/t/finding-duplicate-values-in-lookup-arrays/27585 "2021-06-03T17:59:18Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@AniketP1](https://community.glideapps.com/u/AniketP1)
#### Post date: [June 3, 2021, 5:59pm UTC](https://community.glideapps.com/t/finding-duplicate-values-in-lookup-arrays/27585/1 "2021-06-03T17:59:18Z")
Hi everyone, new to Glide!
Is there a way to find duplicate values between two columns that consist of arrays (retrieved from lookups)? In the example below, I’d love to create a new column that shows this data. For each row, the only value would be “Exercise & Fitness”.
Thanks for any help!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 3, 2021, 7:00pm UTC](https://community.glideapps.com/t/finding-duplicate-values-in-lookup-arrays/27585/2 "2021-06-03T19:00:56Z")
What you can do is take your first lookup and use it to create a second relation to your data. That way you will use your array of Liker Hobbies in a relation to any matching rows in a Likee relation.
You can’t compare two arrays like you’re asking. You have to use the Relation → Lookup → Relation → Lookup method. Hope that makes sense.
---
### Author:  [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)
#### Post date: [January 17, 2024, 4:52pm UTC](https://community.glideapps.com/t/finding-duplicate-values-in-lookup-arrays/27585/3 "2024-01-17T16:52:07Z")