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