Match / Find / Search help please.

[Walshie1987]

Hi All,

I have searched many forums and cannot find an answer to the what i am wanting.

I want to search a cell (Target Cell) to see if it contains words that are in a list (list is about 100 cells long).

If the target cell contains a word from the list, i want to then do a vlookup and insert a category name next the the target cell.

E.g.

Target cell's value is: "Light blue T-Shirt"

The list is as follows:

A | B
Item Name | Category

1 | Jacket | Jackets and Coats

2 | T-Shirt | T-shirts and Polos


I want to insert a formula so the word "T-Shirt" is picked out of the taregt cell (as it is contained in the list), this word is then looked up in the list and the value "T-shirts and Polos" is returned.

I am currently using VBA loop to check all this but with the sizes of the spreadsheet it takes over 20mins to run. Therefore the above formula would be by far quicker.

Please can someone help? I'm pretty good with VBA so VBA suggestions also welcome

Cheers
Chris

 

[Walshie1987]

if someone could show me how to identity if the target cell contains a word from the list I'm sure i could figure out the rest?

Cheers
Chris