Column Type - Lookup & Lookup Count

Avatar

By Rachit

updated 7 days ago

Imagine your boring, lengthy VLOOKUP and INDEX/MATCH formulas in spreadsheets? Well, it's not needed in Stackby. 

You can bring information from other tables in your current table by configuring a Lookup column type. 

Note: Lookup is only possible if you link your tables first (so ideally, the tables of the data that you want to look up have to be linked first). Read this article here on how to link your tables. 


Lookup: 

Here's how to lookup data:

  1. Create a column
  2. Double-click or right click on the header to change the column property
  3. Rename the column with an appropriate title and go to the drop down menu
  4. Select Look Up from the list
  5. Select the column on the table that links to the row you want to lookup from the drop down menu (it will show you all the columns that have been linked)
  6. Next, select the name of the column that you want to lookup
  7. Apply and it is done

As soon as you do this, the column will pull up the data that you wanted to look up.


Link (Lookup) Count: 

Similarly, to lookup the count of data here is the process: 

  1. Create a column
  2. Double-click or right click on the header to change the column property
  3. Rename the column with an appropriate title and go to the drop down menu
  4. Select Look Up Count from the list
  5. Select link column to do lookup count upon (it will show you all the columns that have been linked)
  6. Apply and it is done

The data will bring you a number of the linked rows. 

Did this answer your question?