Do you have to use VLOOKUP, MATCH and INDEX in Jestor?

Who has never used spreadsheets to organize information? Excel helps a lot, but it’s not the ideal. After all, it’s not a database and it’s nothing more than a matrix where you can put text and information that aren’t really connected at all. 

For example, with VLOOKUP, you’re creating a work around by copying information because you cannot truly link one information to the other.

Jestor

On the other hand, with jestor you actually have a record, a combination of data connected to a project. This way, you don’t have to type in formulas or duplicate information. Jestor is more organized and faster!

Creating tables in jestor is also very simple. Just look!

1º) Open jestor. Go to the “+” icon on the left menu, choose the option “table”, name it as you wish and click on “create”. Then add new fields by clicking on the header name with a “+” and create them as you would in Excel, with columns and rows.

NOTE: You can learn more about all types of field here: Tables (jestor.com)

2º) Fill in the information that will be linked to the columns. And unlike Excel, you will really have grouped information.

You can also create other tables and connect them to each other, by adding a connect table field and assigning a task to the project, for example. With just a few clicks, you can find all the information about the project, without using complicated formulas or code.

jestor is a relational database that really makes entrepreneurs’ life easier!