Company
Date Published
Author
Melissa King
Word count
881
Language
English
Hacker News points
None

Summary

If you're struggling to find specific data in a spreadsheet or database, there are more powerful options available to help you quickly locate the information you need. Linked records in databases, such as those found in Airtable, can link multiple tables together and make it easy to pull in one data item from another table. Alternatively, using LOOKUP functions in spreadsheets, like VLOOKUP or HLOOKUP, can also help search through your data and find related values. For more complex scenarios where data is spread across multiple apps, a Zapier automation tool called Formatter by Zapier can be used to mimic the functionality of a LOOKUP function between different tools.