danovkos
11-30-2010, 01:41 AM
Hi all,
pls. is it possible to do following with formula?
I want to use vlookup function for column A.
This column can contains values like e.g. ";ad3;dan;red". All in one cell.
This ";" is separator of my values.
How can i do, that formula will look at this value in cell and will use vlookup for each part of value between separators (;)?
I mean
in A1 is value "ad3,dan;red" and in column B will be formula, which result will be the same as i useded vlookup ("ad3";C1:D20;2;0) & vlookup ("dan";C1:D20;2;0) & vlookup ("red";C1:D20;2;0). Now i can not define, where start separator and then where end and then look for next start of separator and where end and....
The worst is, that value in column A can be with 1 separator (;peter) or max 6 (;peter;red;blue;grey;city;dan). So there can be 1 or 6 partial values. :(
Is it possible to do this with formula?
thx a lot
pls. is it possible to do following with formula?
I want to use vlookup function for column A.
This column can contains values like e.g. ";ad3;dan;red". All in one cell.
This ";" is separator of my values.
How can i do, that formula will look at this value in cell and will use vlookup for each part of value between separators (;)?
I mean
in A1 is value "ad3,dan;red" and in column B will be formula, which result will be the same as i useded vlookup ("ad3";C1:D20;2;0) & vlookup ("dan";C1:D20;2;0) & vlookup ("red";C1:D20;2;0). Now i can not define, where start separator and then where end and then look for next start of separator and where end and....
The worst is, that value in column A can be with 1 separator (;peter) or max 6 (;peter;red;blue;grey;city;dan). So there can be 1 or 6 partial values. :(
Is it possible to do this with formula?
thx a lot