Excel 2007 : Range Contains Text - Then Insert Range from Other Cells

**abulovesall** · 06-22-2010, 04:11 AM

I have a database of 70000 companies records in excel 2007 (in different sheets and work books). I need to enter the Industry field(A3) against each one of them.

I have range of keywords in A1 mentioned below . The name of Companies is in A2(Sample mentioned below).

What i need is a formula that "if the company name (A2) contains (A1) then in A3 it should mention IT/ITES in front of it.

e.g

A1 - software,techno , technology,BPO,KPO

A2 - 3i Infotech Ltd,3M,7Seas Technologies Ltd,A G Technologies Pvt Ltd,A.T. Road Software India Pvt. Ltd,A3TL,AABSyS Information Technology Pvt Ltd,,Aakit Technologies Pvt. Ltd,Aakriti Infotech Inc.

We need in A3 - IT/ITES

Would appreacite if someone can revert back on this. Thanks a Tonne

**stanleydgromjr** · 06-22-2010, 07:53 AM

abulovesall,

Welcome to the Excel Forum.

Please post your workbook with before and after worksheets.

Click on New Post, then scroll down and see Manage Attachments.

**abulovesall** · 06-22-2010, 12:30 PM

Hey can i have some inputs now?

**stanleydgromjr** · 06-22-2010, 07:17 PM

abulovesall,

Detach/open workbook Keyword Arrays - enter Industry codes - VP - abulovesall - SDG13.xlsm and run macro FindKeywords on worksheets Before, and After.

The macro will cycle thru worksheet Keywords, and create an array for each column of data, and then check column 1 in the worksheets for the keywords, and enter the Industry code in the column to the right.