Spreadsheet: 757174d1638086201-index-and-match-formula-with-an-if-condition-indexmatch
Sheet: Missing

Main List |  |  |  |  |  |  |  |  |  | workbook 1 list |  |  | workbook 2 list |  |  |  |  |  | Found in workbook1 list ? |  |  |  |  | Found in workbook2 list?
Code |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IF(INDEX($C$3:$C$90,MATCH(K3:K24,$AJ$3:$AL$3,0)))
Ind | A | Agriculture, forestry and fishing |  |  |  |  |  |  |  | Construction |  |  | 0610 Crude Oil |  |  |  |  |  | No |  |  |  |  | no
 | B | Mining and quarrying |  |  |  |  |  |  |  | Sales_of_motor_ |  |  | 0620 Natural Gas |  |  |  |  |  | no |  |  |  |  | yes
B | 05 + 07 + 08 | Other mining and quarrying |  |  |  |  |  |  |  | Wholesale |  |  | B- Mining and quarrying
0610 | 0610 | Extraction of crude petroleum |  |  |  |  |  |  |  | Land Transport |  |  | 1921 Production of liquid fuels
0620 | 0620 | Extraction of natural gas |  |  |  |  |  |  |  | Water_Transport_ |  |  | 2011 Manufacture of basic chemicals
B | 09 | Mining support service activities |  |  |  |  |  |  |  | Air_Transport |  |  | 2012 Manufacture of fertilizers
 | C | Manufacturing |  |  |  |  |  |  |  | Warehousing_activity |  |  | 2013 Manufacture of plastics  in primary forms
C | 10 to 12 | Manufacture of food products, beverages and tobacco products |  |  |  |  |  |  |  | Food_and_Beverage |  |  | 2410 Manufacture of basic iron and steel
C | 13 to 15 | Manufacture of textiles, wearing apparel, leather and related products |  |  |  |  |  |  |  | Financial_Service |  |  | 2432 Casting of non-ferrous metals
C | 16 to 18 | Manufacture of wood and paper products; printing and reproduction of recorded media |  |  |  |  |  |  |  | RealEstate |  |  | C - Manufacturing
1921 + 1922 | 1921 + 1922 | The production of liquid fuels ( petroleum gasoline, jet fuel, kerosene, diesel and oil refinery products, butane, propane) |  |  |  |  |  |  |  | Legal_Services |  |  | 3511
2011 | 2011 | Manufacture of basic chemicals |  |  |  |  |  |  |  | Management |  |  | 3600
2012 | 2012 | Manufacture of fertilizers and nitrogen compounds |  |  |  |  |  |  |  | Engineering Activities |  |  | 3511 + 3600 Water and Electricity
2013 | 2013 | Manufacture of plastics and synthetic rubber in primary forms |  |  |  |  |  |  |  | Advertising_research |  |  | D + E - Electricity, gas,  water supply, sewerage and  waste management
C | 202 + 203 + 21 | Manufacture of machinery and equipment |  |  |  |  |  |  |  | Rental_and_Leasing |  |  | General
C | 22 + 23 | Manufacture of furniture |  |  |  |  |  |  |  | Employment activties
C | 2394 | Other manufacturing; repair and installation of machinery and equipment |  |  |  |  |  |  |  | Travel_agency
C | 2395 | Electricity, gas,  water supply, sewerage and  waste management |  |  |  |  |  |  |  | Security_and_investigation
2410 | 2410 | Electricity, water, gas, steam and air conditioning supply |  |  |  |  |  |  |  | Buildings_and_Landscape
2432 | 2432 | Sewerage, waste management and remediation |  |  |  |  |  |  |  | Education
C | 2511 | Construction |  |  |  |  |  |  |  | Health
C | 27 to 30 | Construction of buildings |  |  |  |  |  |  |  | Other_Social_activities
C | 31 | Civil engineering
C | 33 + 32 + 25r +24r | Specialized construction activities
 | D + E | Households
D + E | 35 to 36 | Wholesale and retail trade; repair of motor vehicles and motorcycles
D + E | 37 to 39 | Wholesale and retail trade and repair of motor vehicles and motorcycles
 | F | Wholesale trade, except of motor vehicles and motorcycles
F | 41 | Retail trade, except of motor vehicles and motorcycles
F | 42 | Households
F | 43 | Transportation and storage
F | Fh | Land transport and transport via pipelines
 | G | Households
G | 45 | Water transport
G | 46 | Air transport
G | 47 | Warehousing and support activities for transportation
G | 47h | Postal and courier activities
 | H | Accommodation and food service activities
H | 49 | Accommodation
 | 49h | Food and beverage service activities
H | 50 | Information and communication
H | 51 | Publishing, audiovisual and broadcasting activities
H | 52 | Telecommunications
H | 53 | IT and other information services
 | I | Financial and insurance activities
I | 55 | Monetary intermediation
I | 56 | Activities of holding companies
 | J | Other financial service activities, except insurance and pension funding activities
J | 58 to 60 | Insurance, reinsurance and pension funding, except compulsory social security
J | 61 | Activities auxiliary to financial service and insurance activities
J | 62 + 63 | Real estate activities
 | K | Real estate activities
K | 641 | Households
K | 642 | Professional, scientific and technical activities
K | 649 | Legal and accounting activities
K | 65 | Activities of head offices; management consultancy activities
K | 66 | Architectural and engineering activities and related technical consultancy
 | L | Technical testing and analysis
L | 68 | Scientific research and development
L | 68h | Advertising and market research
 | M | Other professional, scientific and technical activities
M | 69 | Veterinary activities
M | 70 | Administrative and support service activities
M | 7110 | Rental and leasing activities
M | 7120 | Employment activities
M | 72 | Travel agency, tour operator, reservation service and related activities
M | 73 | Security and investigation activities
M | 74 | Services to buildings and landscape activities
M | 75 | Office administrative, office support and other business support activities
 | N | Education (Private)
N | 77 | Education
N | 78 | Human health and social work activities (Private)
N | 79 | Human health activities
N | 80 | Arts, entertainment and recreation (Private)
N | 81 | Creative, arts and entertainment activities
N | 82 | Libraries, archives, museums and other cultural activities
 | P | Sports activities and amusement and recreation activities
P | 85 | Other service activities
 | Q | Activities of membership organizations
Q | 86 | Repair of computers and personal and household goods
 | R | Other personal service activities
 | D21