It can be tricky to use formula on the canva but here I’ve got 2 apparently working formulas :

Here, it’s not really a problem of different variables (well there is one in your `lookup()`

), but a missing part and that’s why both formulas use `.Value`

to indicate to the formula that you’re looking for a precise data for the actual `value`

selected in your select list (otherwise, the data you’re looking for could be the data of any selectable options referenced by your select list). So you weren’t that far with your `Lookup()`

Because your select list is already a reference, you can just use this first formula that sort of say that for the `.Value`

selected in the select list, get the `Stundenziel`

`[Select-Kunde].Value.Stundenziel`

The second formula is a `Lookup()`

that compares the `Text`

field `[Kürzel]`

in your table `Projekte`

to the actual `Value`

of your select list, which is a reference at this point. So to pull out the `Text`

field and make the comparison doable, you need to indicate where to get the `Text`

: in this case, it’s the field `[Kürzel]`

too : which gives you this part of the formula : `[Select-Kunde].Value.[Kürzel]`

.

`Lookup(Projekte,[Kürzel],[Select-Kunde].Value.[Kürzel]).Stundenziel`

I’m not sure it’s very clear, but it’s really hard to explain those kind of subtleties