Excel: VLOOKUP and INDEX+MATCH return #REF

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.