Match Data from Different Sheets with one and/or more keyterms

[Blessy Clara]

Hi All

I have two excel sheets
Sheet1: Has ANZSIC Codes
Sheet 2: Has Data to which the ANZSIC codes must be assigned

Sheet 1 Data Example

0111 Nursery Production (Under Cover)

0112 Nursery Production (Outdoors)

0113 Turf Growing

0114 Floriculture Production (Under Cover)

0115 Floriculture Production (Outdoors)

0121 Mushroom Growing

0122 Vegetable Growing (Under Cover)

0123 Vegetable Growing (Outdoors)

0131 Grape Growing

0132 Kiwifruit Growing

0133 Berry Fruit Growing

0134 Apple and Pear Growing

0135 Stone Fruit Growing

0136 Citrus Fruit Growing

0137 Olive Growing

0139 Other Fruit and Tree Nut Growing

0141 Sheep Farming (Specialised)

0142 Beef Cattle Farming (Specialised)

0143 Beef Cattle Feedlots (Specialised)

0144 Sheep-Beef Cattle Farming

0145 Grain-Sheep or Grain-Beef Cattle Farming

0146 Rice Growing

0149 Other Grain Growing

0151 Sugar Cane Growing

0152 Cotton Growing

0159 Other Crop Growing n.e.c.

0160 Dairy Cattle Farming

0171 Poultry Farming (Meat)

0172 Poultry Farming (Eggs)

0180 Deer Farming

0191 Horse Farming

0192 Pig Farming

0193 Beekeeping

0199 Other Livestock Farming n.e.c.

0201 Offshore Longline and Rack Aquaculture

0202 Offshore Caged Aquaculture

0203 Onshore Aquaculture

0301 Forestry

0302 Logging

0411 Rock Lobster and Crab Potting

0412 Prawn Fishing

0413 Line Fishing

0414 Fish Trawling, Seining and Netting

0419 Other Fishing

0420 Hunting and Trapping

0510 Forestry Support Services

0521 Cotton Ginning

0522 Shearing Services

0529 Other Agriculture and Fishing Support Services

0600 Coal Mining

0700 Oil and Gas Extraction

0801 Iron Ore Mining

0802 Bauxite Mining

0803 Copper Ore Mining

0804 Gold Ore Mining

0805 Mineral Sand Mining

0806 Nickel Ore Mining

Sheet 2 Data Example

CATEGORY

Accounting & Accounting Services

Advertising & Marketing

Agriculture

Architecture

Architecture Services

Architecture, Engineering & Design

Automotive

Banking

Biotechnology

Building Materials

Business Services

Business Services, Education

Chambers Of Commerce

Chemicals

Chemicals, Petrochemicals, Glass & Gases

Civil Engineering

Colleges & Universities

Commercial & Residential Construction

Commercial Printing

Computer Software

Construction

Consumer Electronics

Consumer Goods

Consumer Services

Consumer Services, Hospitality

Cultural, Retail

RESULT
Criteria/Rule : One and / Or all terms in Sheet 2 must be matched with Sheet1 data
Each matching Code has to be assigned in adjacent columns

Accounting & Accounting Services

CATEGORY	Matching Term
Accounting & Accounting Services		6932 Accounting Services
Advertising & Marketing		6940 Advertising Services
Agriculture		0529 Other Agriculture and Fishing Support Services
Architecture	Architect	6921 Architectural Services	2223 Architectural Aluminium Product Manufacturing
Architecture Services		6921 Architectural Services
Architecture, Engineering & Design	Architect, and /or Engineering, and/or Design	6921 Architectural Services	2223 Architectural Aluminium Product Manufacturing	6923 Engineering Design and Engineering Consulting Services	3109 Other Heavy and Civil Engineering Construction	6923 Engineering Design and Engineering Consulting Services	6924 Other Specialised Design Services	7000 Computer System Design and Related Services

In Simple Terms - It is like using Find ALL for One/More keywords and entering the Codes from Sheet 1 to the DATA

Any solution would be very helpful

Thank you