Goodlookup

What Goodlookup is

A spreadsheet function that matches by meaning. Where a lookup needs exact keys, this finds rows that mean the same thing even when the text differs.

It is used inside Google Sheets formulas alongside the functions you already know.

What you can do with it

• Match customer or company names across sheets
• Cluster hashtags, categories or topics
• Deduplicate inconsistent text entries
• Link records between two tables
• Clean up survey or content data
• Score similarity between entries

Who it is for

• Data and operations staff
• Market and content analysts
• Sales operations teams
• Anyone cleaning messy text in sheets

What to watch out for

• Semantic matching can pair things your business treats as different: review the results
• Similarity scores help judgement but do not replace it
• Customer and personal data in sheets needs care with sharing and retention
• Verify results before merging or deleting records