Adonaioc
11-09-2009, 01:06 PM
We have a master worksheet that gets populated from a database weekly
it has 2 relevant columns a and b, A is the item number and B is the description. The Vlookup seems to get broken every time the master is updated, It seems that the name manger does not recognize it or something. I was wondering if there was a way to make it so that the vlookup looks at the document with that name regardless of whether or not it has been written over.
The other problem I have is that the database that spits out the master sheet adds spaces on the end of any string that does not meet the 15 character limit,
eg
apple would have 10 extra spaces on the end but
NewYorkers would only have 5 is there a way to make the V lookup recognize the extra spaces and nothing. because as it is now I have to type the extra spaces or it acts like the lookup does not exist.
it has 2 relevant columns a and b, A is the item number and B is the description. The Vlookup seems to get broken every time the master is updated, It seems that the name manger does not recognize it or something. I was wondering if there was a way to make it so that the vlookup looks at the document with that name regardless of whether or not it has been written over.
The other problem I have is that the database that spits out the master sheet adds spaces on the end of any string that does not meet the 15 character limit,
eg
apple would have 10 extra spaces on the end but
NewYorkers would only have 5 is there a way to make the V lookup recognize the extra spaces and nothing. because as it is now I have to type the extra spaces or it acts like the lookup does not exist.