I have a vlookup function on the one (1) sheet that look up at the cell's
values with a product code such as SBP, SBT, SN8, SN7, ... at the other sheet
(2):
=IF(ISERROR(VLOOKUP(A57,MasterData,10,0)),"",VLOOK UP(A57,MasterData,10,0))

This product code column is a first column in a MasterData range on the
sheet 1 and it's a first column on the sheet 2. For many cells everything is
fine the function is taking the value. But, for some ones there is no value -
it's empty. Only, after
I retype manually the same product code in a cell on the sheet 2 where the
function cannot get a data the value is appearing.

How possibly I could fix it?

Thanks