Searching by Keyword

[Loop Stepwalker]

Hello,

I have a list of product codes and product descriptions in column A&B of one tab, as per below

3867 Halibut Supremes
3881 Brake Rindless Bac
3886 Brake Lamb Chops
3889 Brake Pork Chops
3890 LaBo 10" PB White

I want to be able to create a search based on a keyword, for example Brake. That would return the product code of every product containing that word

I have manged to do this but its slower than slow, looks wrong and unnecessarily complicated:

=IF($B$2="","",IF(SUM(IF(ISNUMBER(SEARCH($B$2,table1)),1,0))<ROWS($B5:$B$5),"",INDEX(table2,SMALL(IF(ISNUMBER(SEARCH($B$2,table1)),ROW(INDIRECT("1:"&ROWS(table2))),""),ROWS($B5:$B$5)))))

Table1 is the Description column and table2 is the Code column.

Any help would be much appreciated

Thanks

[AndyLitch]

Database Search Example.xls

Try this... Copy and paste your data into range(A11:Jxxx) of the data worksheet

[Loop Stepwalker]

Thanks very much for the quick response, i'll have a little play around with this.

Thanks again