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.
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