| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup left
I would like to use vlookup to look for all the characters at the right of a
column until the (:) sign, (see sample below) I cant use the num_chars because its not always the same amount of characters after the colon sign (:) FISH IN BAGS:12a FISH IN BAGS:P24 FISH IN BOX:P12 FISH IN BAGS:PN24 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP LEFT VS RIGHT | Excel Worksheet Functions | |||
| Vlookup from left to right. | Excel Worksheet Functions | |||
| Vlookup to the left | Excel Worksheet Functions | |||
| VLOOKUP *Left* Value | Excel Discussion (Misc queries) | |||
| Vlookup and left function | Excel Discussion (Misc queries) | |||
Threaded Mode
