I'm using this formula to get value form a table

```
=LOOKUP(C11;Alias[A];Alias[B])
```

where C11 = 12354567

But when I use

```
=LOOKUP(LEFT(C11,7);Alias[A];Alias[B])
```

where C11 = 12345678, the formula does not work.

Evaluating formula I have found out that `LEFT`

adds double quotes making the formula like this:

```
=LOOKUP("1234567";Alias[A];Alias[B])
```

How to approach that problem ?