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!