Your problem may be that the results from your LEFT() function are text and
you're looking in a series of numbers. Try this:

=VLookUp(Value(Left(mycell,6),lookuprange,index))

HTH,
Elkar


"Bobby" wrote:

> Hello
> I am having trouble with a lookup formula. The lookup value is in a cell
> with several other comma delimited values, ie., 123456, 12345678, 123452.
> The value I want to use is the portion to the left of the first comma. The
> numbers will either be 6 or 8 digits. With 2 8 digit numbers I have tried
> vlookup(left(mycell,lookuprange,index)) but this is returning N/A. Is there
> a way to do this without doing a text to columns?
> Thanks!