Hi there!

In Grist, you can use lookup functions to find values in other tables. Grist has lookupOne which finds a single record that matches the parameters given and lookupRecords which finds a list of records that match the parameters given.

Our References and Lookups article goes over these two functions in depth.

Because you are looking for a single record where the RiskDegree (Number) match, we will use lookupOne.

I created an example (based on your explanation) for you: Community #1545 - Grist

The āRisk Degree - Textā column of the āRisk Probabilityā table contains the following lookupOne function:

```
Risk_Degree.lookupOne(Number=$Risk_Degree_Num).Value
```

The general format for a lookupOne formula is:

```
[Table_Name].lookupOne([A]=$[B])
```

`[Table_Name]`

is the name of the table you want to lookup data in. In the example, the table we are looking up data in is the āRisk Degreeā table.

`[A]=$[B]`

is what two columns are we trying to match in order to find the correct record.

`[A]`

is the column in the table being looked up (named at the beginning of the formula). In our example, we are looking up the āNumberā column in the āRisk Degreeā table

`[B]`

is the column in the current table / the table you are entering the formula in. In our example, thatās the āRisk Degree - Numā column. We want to match the value in the āRisk Degree - Numā column to a value in the āNumberā column of the āRisk Degreeā table.

LookupOne function finds a record. So in this case, it finds the entire record in the āRisk Degreeā table where the value in the āNumberā column matches the value in the āRisk Degree - Numā column of the āRisk Probabilityā table.

At the end of the formula, we have `.Value`

. We use dot notation to pull the value from the Value column for the record we found with our lookupOne function.

Let me know if you have any questions.

Thanks,

Natalie