I have data like this

```
Time    chamber
9       1
10      2
11      3
12      4
13      5
14      6
15      7
16      8
17      9
18      10
19      11
20      12
21      1
22      2
23      3
24      4

```

I want to create a new column using conditions on another existing column (chamber). 

It should look something like this

```
Time    chamber treatment
9       1       c2t2
10      2       c2t2
11      3       c0t0r
12      4       c2t2r
13      5       c2t2r
14      6       c0t0
15      7       c0t0r
16      8       c0t0r
17      9       c2t2
18      10      c2t2r
19      11      c0t0
20      12      c0t0
21      1       c2t2
22      2       c2t2
23      3       c0t0r
24      4       c2t2r

```

* For chambers 1,2,9: Treatment is `c2t2`
* For chambers 3,7,8: Treatment is `c0t0r`.
* For chambers 4,5,10: Treatment is `c2t2r`
* For chambers 6,11,12: Treatment is `c0t0`.

I have also made a lookup table, but I don't know how to use it:

```
lookup_table <- data.frame(row.names = c("1", "2", "3","4", "5", "6","7", "8", "9","10", "11", "12"),
                           new_col = c("C2T2", "C2T2", "C0T0R","C2T2R", "C2T2R", "C0T0","C0T0R", "C0T0R", "C2T2","C2T2R", "C0T0", "C0T0"), 
                           stringsAsFactors = FALSE)    

```