Hello All, | |
Here is the sample strings in (A2:A11) | result(B2:B11) |
Lorem ipsum dolor sit amet, amber amber consectetur beige adipiscing elit. | amber|beige |
Nunc azure dictum black odio light blue quis nunc imperdiet viverra. | black|light blue|blue |
Sed at beige beige beige amber urna beige et bronze massa porttitor molestie. | beige|amber|bronze |
Phasellus ut massa non urna eleifend ornare vel sed turpis. | |
Mauris volutpat sem blue et faucibus convallis. | blue |
Curabitur non risus quis arcu hendrerit luctus eget vel dui. | |
Etiam non libero consequat, laoreet quam sit amet, ornare dolor. | |
Phasellus nec black ipsum bibendum, fringilla sem non, vehicula metus. | black |
Morbi a lacus black pulvinar, cursus nisi at, vulputate sapien. | black |
Curabitur tincidunt elit id ultricies fermentumbronze azure elit id. | azure(only exact match) |
and i have range of words in (E17:E23), in this case colors but can be a number,text, alphanumeric digit as well | |
amber | |
azure | |
beige | |
black | |
light blue | |
bronze | |
blue | |
I m looking for a solution either it be any formula, function or macros. | |
I have range of words which i need to find in the list of strings to obtain the desired result, hopefully the above data could help. | |
any help would be highly appreciated. | |
Thanks |
<tbody>
</tbody>