Hello,
I have the following table, column A contains string that repeats in some form, like front, front-l30, the word "front" is found in all, and I want a code that loops each row and it it finds the whole specified word in a case loop than it write to column B a specific value.
To make it clear, for the bellow example:
If search string="front" then write "10"
else if search string="front-l30 then write "20"
else if search string='front-r30 then write "30"
I tried to combine some code found here but without success.
Any help is appreciated.
Thank you!
I have the following table, column A contains string that repeats in some form, like front, front-l30, the word "front" is found in all, and I want a code that loops each row and it it finds the whole specified word in a case loop than it write to column B a specific value.
To make it clear, for the bellow example:
If search string="front" then write "10"
else if search string="front-l30 then write "20"
else if search string='front-r30 then write "30"
I tried to combine some code found here but without success.
Any help is appreciated.
Thank you!
Front | 10 |
Front-L30 | 20 |
Front-R30 | 30 |