I reread the opening post several times, and I don't understand, what kind of data you have where, and what you want to get as result!

You have 2 pages.
On page Codes you have data in columns A and B.
On page NoName you have data in Column A, and you want to have a formula in some other column.

1. What type of data (numeric or text) you have in column NoName.A? Is the type always same, or it can vary?
2. What type of data you have in column Codes.A? Is the type always same, or it can vary?
3. For both columns, are real formats for cells same as cell format? In excel when you p.e. have a cell formatted as text with numeric value entered, and later you change the cell format to number, the entry remains a text until you edit the cell (and vice versa). To correct entry formats for a range:
a) when new format is numeric, save a value 1 or 0 into some free cell, copy it, select the range you want to correct formats at, and from dropdown menu select PasteSpecial.Multiply or PasteSpecial Add (depending the value you copied before);
b) when the new format is text, into free column on first datarow enter the formula like , and copy down. Copy all cells with formula, and overwrite the values in column you want to correct formats at using PasteSpecial.Values;
4. Are data types always same in columns NoName.A and Codes.A?
5. What is data type in column Codes.B? From your post:
Or do you mean NoName.B in second sentence of citation here?
6. What do you want get for result? The value from column B of sheet NoName multiplied with 2 or 0, depending on result of vlookup? Or something else?