Hi,
How do I search column B (Products), for a certain word and return it to column C (Item) using VBA?
In VBA, I would like it to search for certain words such as "Small", "Medium", and "Large". If none of these words are found, I would like it to return "Other".
So if the first product is SMALL CARS, it will return SMALL under ITEM. CLOTHES will return OTHER.
I know I could just use the LOOKUP function, but I would like to build this under VBA.
Thank you!
<tbody>
</tbody>
How do I search column B (Products), for a certain word and return it to column C (Item) using VBA?
In VBA, I would like it to search for certain words such as "Small", "Medium", and "Large". If none of these words are found, I would like it to return "Other".
So if the first product is SMALL CARS, it will return SMALL under ITEM. CLOTHES will return OTHER.
I know I could just use the LOOKUP function, but I would like to build this under VBA.
Thank you!
Company | PRODUCTS | ITEM | PRICE | |
ABC | SMALL CARS | 100 | ||
ABC | MEDIUM CARS | 200 | ||
ABC | LARGE CARS | 300 | ||
ABC | CLOTHES | 400 | ||
ABC | ELECTRONICS | 500 |
<tbody>
</tbody>