Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How to set up lookup from ground 0

Topic Labels: Base design
322 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Guys, I am completely new to this type of database, only experience comes from excel/sheets, so forgive me for my basic question but none of the videos shows a true step by step for a simple lookup, and it is quite unclear what to link with what, I do not get results…

What I’d like to do is simple:

  1. Create a table with dfferent client Types with different unit prices.
    eg.
    Small
    Medium
    Large

and in a parallel column:
5
10
20
for unit prices.

  1. Creatw another table where client Types are listed ( not entered, but they are calculated based on an IF formula, that I managed to do based on their employee count)

  2. Assign unit prices to those client Types based on the first table.

Third one is my problem, no matter how I am trying to link stuff, no results appear, sometimes empty additional columns are added to either of the tables… Quite lost here, thank you for your support.

Br,
Daniel

0 Replies 0