| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup left
If you want to do that then why don't you look at your post of 20 minutes ago?
"Mottyb" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
vlookup left
This is not a LOOKUP nor a VLOOKUP. Check your earlier thread - you
have two replies there already. Pete On Nov 22, 7:44 pm, Mottyb wrote: 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 can't use the num_chars because it's 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 |
| Reply |
| 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) | |||
Hybrid Mode
