Match Keyword in Excel

[Mohanmoni]

Hi,

I am looking for formula that match keyword in from 2 files.

File1:

Keywords Exclude

intern

accountant

accounting

admin

advertising

advisor

analyst

architect

assistant to vice president

assistant to vp

Attorney

auditor

Author

brand

Building

Bus Development

business

cafeteria

cash

Category

catering and File2: Title Vice President - Operations Senior Product Manager, Single Cell Genomics Vice President, Architect Manufacturing And Process Development Head of Manufacturing Systems Architect Director - Operations Operations Analyst Operations Specialist Director of Operations Residential Operations Admin. Manager Director of Operations Operations Manager Now I want the formula the find Keyword mentioned in file1 & Match with File2. Thanks, Mohan <colgroup><col></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

 

[jtakw]

Hi,

As you didn't explain how you want your results, and I'm not sure what you mean by "file1", "file2", different workbooks, or tabs?

Anyway, maybe this will get you started:

Book1
	A	B	C	D	E
1	Keywords Exclude		Title		Keyword
2	intern		Vice President - Operations
3	accountant		Senior Product Manager, Single Cell Genomics
4	accounting		Vice President, Architect Manufacturing And Process Development		architect
5	admin		Head of Manufacturing Systems Architect		architect
6	advertising		Director - Operations
7	advisor		Operations Analyst		analyst
8	analyst		Operations Specialist
9	architect		Director of Operations
10	assistant to vice president		Residential Operations Admin. Manager
11	assistant to vp		Director of Operations
12	Attorney		Operations Manager
13	auditor
14	Author
15	brand
16	Building
17	Bus Development
18	business
19	cafeteria
20	cash
21	Category
22	catering
Sheet323

Cell Formulas
Range	Formula
E2	=IFERROR(LOOKUP(2,1/SEARCH(" "&A$2:A$22&" "," "&C2&" "),A$2:A$22),"")

E2 formula copied down.

 

[Aladin Akyurek]

=IFERROR(LOOKUP(9.99999999999999E+307,SEARCH(" "&A$2:A$22&" "," "&C2&" "),A$2:A$22),"")

which is faster...