| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a simple solution?
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros in Excel(probably a simple solution) | Excel Discussion (Misc queries) | |||
| Show trial solution | Excel Worksheet Functions | |||
| Surely a simple solution exists | Excel Worksheet Functions | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| Generating excel combinations | Excel Discussion (Misc queries) | |||
Threaded Mode
