Thanks guys ,,, works well ,,,, I had an idea it was because of the numeric
text ,,,, thanks again

"bpeltzer" wrote:

I'll take a guess that the table in which you're looking for 6223 is numeric;
the result of the LEFT function is still a string (even though it's a string
of numbers). Convert it to a value and your lookup may work:
=vlookup(value(b1),data,2,0)

"John Moore" wrote:

Sorry ,,, would help if I posted the example ...

Col A Col B Col C
6223BD2 6223 #NA


"John Moore" wrote:

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 ?