vlookup cannot see value for some cells
 

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

vlookup cannot see value for some cells
 

As a best guess you downloaded this data from some sort of a data base?
Sometimes when you do that some or all of the data will be padded with blank
spaces at the end. "This" and "This " are 2 different things. Try using a
helper column with the trim function in it to remove the padded blanks at the
end (if this is the case)...
--
HTH...

Jim Thomlinson


"Alex" wrote:

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

vlookup cannot see value for some cells
 

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

vlookup cannot see value for some cells
 

Thank you very much, Jim.
You're right it'a a database data. I've used Trim and everything is working
perfectly now.

"Jim Thomlinson" wrote:

As a best guess you downloaded this data from some sort of a data base?
Sometimes when you do that some or all of the data will be padded with blank
spaces at the end. "This" and "This " are 2 different things. Try using a
helper column with the trim function in it to remove the padded blanks at the
end (if this is the case)...
--
HTH...

Jim Thomlinson


"Alex" wrote:

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

vlookup cannot see value for some cells
 

Thank you very much, Jim.

You're right it's a database data. I've used Trim and everything is working
perfectly now.

"Jim Thomlinson" wrote:

As a best guess you downloaded this data from some sort of a data base?
Sometimes when you do that some or all of the data will be padded with blank
spaces at the end. "This" and "This " are 2 different things. Try using a
helper column with the trim function in it to remove the padded blanks at the
end (if this is the case)...
--
HTH...

Jim Thomlinson


"Alex" wrote:

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