Trying to get a simple Vlookup to work ,,, and it has me perplexed ,,,,
example below ,,,,,, column A contains the original data, column B contains a
LEFT function of colunm A ,,, i.e. =LEFT(A1,4,0), to return the first 4
characters of A1, column C is where I have a Vlookup, lookup is based on a
range, called data, so would look like this , =VLOOKUP(B1,data,2,0) ,,,,,
this returns an #NA error, even though the data in B1 exits in the range, how
do I solution this ,,,,,is there a way to do a vlookup on cell A1 ( first
four characters only ) without doing an =LEFT in coulmn B ?