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

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

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