Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup with merged cells | Excel Worksheet Functions | |||
VLOOKUP using 2 Cells | Excel Worksheet Functions | |||
VLOOKUP 2 CELLS | Excel Programming | |||
Vlookup value between 2 cells | Excel Worksheet Functions | |||
Vlookup on multiple cells | Excel Worksheet Functions |