
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 07:36 AM
Has anyone seen duplicated content resulting from a Lookup?
I’ve noticed this in a couple different tables and it is causing formula errors for me.
For example, I have a lookup on a single select field with only these options: http://photoville.org/uploads/2020-08-05_073451_3zvyyjo.png
Yet, in the resulting field, there are sporadic entries that appear as ‘Clinical Trial, Clinical Trial’
When I subsequently attempt to use this field in a Switch(), I get ‘#ERROR!’ in those case where the entry is duplicated.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 07:45 AM
Welcome to the Airtable community!
Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.
An alternative is to use a rollup field with the ARRAYUNIQUE(values)
formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 07:45 AM
Welcome to the Airtable community!
Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.
An alternative is to use a rollup field with the ARRAYUNIQUE(values)
formula.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 05, 2020 07:58 AM
Thank you, that totally was the problem, and a nice solution!
