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!