How do I create a lookup database in Stackby?

I’m trying to set up a lookup database in Stackby, similar to how it’s done in Excel. I want to pull data from one table into another based on a common field. Can someone guide me on how to create this setup? Any examples or tips would be helpful!

You need to first create a link column type to create relationships across your tables and then lookup any column data from one table to another using the Lookup column.

Stackby is a database, not a spreadsheet. So linking records between two tables is pretty straightforward - where you can create one-one, one-many and many-many relationships across records between two tables. Eg. Product to Clients or Applicants to Job Positions.

Here’s the quick guide on Link & Lookup in your database.

It’s different than VLOOKUP and HLOOKUP in Excel.