I am trying to make cells in one sheet look up a name in another sheet, and return the value one column to the right of the cell with the name. In itself, a perfect job for VLOOKUP. But, when I implement this in practice, with the formula `=VLOOKUP(B2;TypeID!$A$2:$A$8999;2;FALSE)`, the cell displays "#REF", describing it as "Invalid Cell Reference Error". 

I have tried substituting VLOOKUP with an INDEX+MATCH combination, but with the exact same results. I have manually assured that the values in both the lookup\_value cell and the table\_array cells are the same, with `=B2=TypeID!A592`, and that they are of the same type, with `TYPE`. When I use VLOOKUP with index at 1, it returns the value of the cell correctly.

It might be worth noting that the lookup\_value and table\_array cells are text, but the value I want returned, from the col\_index\_num cell, is a number.

A small exerpt from the TypeID sheet:

```
A                     B
1 Amber Cytoserocin  |  ISK 89 999,97 
2 Amber Mykoserocin  |  ISK 2 500,00 

```

I want to look up a match in the `A` column, then extract the neighboring value from the `B` column.