Sounds like some of the product codes on the lookup sheet have leading or
trailing spaces.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Alex" wrote in message
...
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