sorry for creating another thread but in previous thread i forgot to mention this (i also tried but i failed)
i have these strings:
blah-blah-blahCK-N-blah
blah-blah-blahLX-N-blah
blah-blah-blahXF-V-blah
and i have these "conditions" (2 different's) in "vlookup conditions" sheet:
please help me with 2 different codes which:
- if 2 last words of the 3rd block (the block between the 2nd dash and the 3rd dash, from left) are CK (or LX) then 3 (if theyre XF then 4)
- if the 4th block (the block between the 3rd dash and the 4th dash, from left) is V (or N) then 1 (or 2) ---> if its either V or N then nothing show (not error)
thank you all.
i have these strings:
blah-blah-blahCK-N-blah
blah-blah-blahLX-N-blah
blah-blah-blahXF-V-blah
and i have these "conditions" (2 different's) in "vlookup conditions" sheet:

please help me with 2 different codes which:
- if 2 last words of the 3rd block (the block between the 2nd dash and the 3rd dash, from left) are CK (or LX) then 3 (if theyre XF then 4)
- if the 4th block (the block between the 3rd dash and the 4th dash, from left) is V (or N) then 1 (or 2) ---> if its either V or N then nothing show (not error)
thank you all.
Last edited: