Spreadsheet: 689580d1596529705-is-countif-the-correct-function-to-match-a-substring-in-a-range-to-a-selected-value-excelforum-1-
Sheet: Category

CATID | Category Of Vendor |  | PRODID | CATID | Product Supplied by Vendor |  | MFID | PRODID | MANID | Manufacturer | Part Name
CAT1 | Business Services |  | PRO1 | CAT7 | Actuators |  | MF1 | PRO21 |  | ABB | Nema Motor
CAT2 | Capital Equipment |  | PRO2 | CAT7 | AV Mounts |  | MF2 | PRO21 | S1234 | Siemens | xyz
CAT3 | Clear & Forward |  | PRO3 | CAT10 | [NAME] |  | MF3 | PRO23 |  | Fenner | V Belt
CAT4 | Consumables |  | PRO4 | CAT10 | [NAME] |  | MF4
CAT5 | Establishment Expenses |  | PRO5 | CAT10 | Base Frame |  | MF5
[NAME] | Fabrication |  | PRO6 | CAT10 | Bearing housing |  | MF6
CAT7 | Fan Accessories |  | PRO7 | CAT10 | Bearings |  | MF7
CAT8 | Fan Instruments |  | PRO8 | CAT10 | [NAME] |  | MF8
CAT9 | Fan Motors and Motor Accessories |  | PRO9 | CAT10 | Blades-disassembled |  | MF9
CAT10 | [NAME] |  | PRO10 | CAT8 | Brakes
CAT11 | Imports |  | PRO11 | CAT10 | Casing |  | HSNID | HSN Code | HSN Desc
CAT12 | Insurance |  | PRO12 | CAT10 | [NAME] |  | HID1 | 3208 90 | Paint / Hardner
CAT13 | Job Work |  | [NAME] | CAT10 | [NAME] |  | HID2 | 3208 9029
CAT14 | Material Handling (and/or Labour charge) |  | PRO14 | CAT10 | Couplings |  | [NAME] | 3209 80
CAT15 | Packing Materials and/ or Charges |  | PRO15 | CAT7 | Dampers : Inlet |  | HID4 | 3403 | [NAME] remover
CAT16 | R&M : Equipment |  | PRO16 | CAT7 | Dampers : Outlet |  | HID5 | 3403 9900
CAT17 | R&M : Establishment |  | PRO17 | CAT7 | Expansion Joints |  | HID6 | 3814 00 | Thinner
CAT18 | Staff Welfare |  | PRO18 | CAT10 | Fan with motor |  | HID7 | 3910 0090
CAT19 | Transport |  | PRO19 | CAT10 | Fan with motor+accessories |  | HID8 | 3919 1000 | Self Adhesive Tape
CAT20 | Utilities |  | PRO20 | CAT7 | Filters |  | HID9 | 3919 9090
 |  |  | PRO21 | CAT7 | Flexible Connections : Inlet |  | HID10 | 3920 | Rubber Beeding  Gasket
 |  |  | [NAME] | CAT7 | Flexible Connections : Outlet |  | HID11 | 3920 1019
 |  |  | PRO23 | CAT7 | Guide Vane |  | HID12 | 3921 9099 | Stretch wrap film
 |  |  | PRO24 | CAT10 | Hubs-disassembled |  | HID13 | 3923 | Packing cover / Cable Tie
 |  |  | PRO25 | CAT10 | Inlet Cone |  | HID14 | 3923 9090
 |  |  | PRO26 | CAT10 | Inlet Side Casing |  | HID15 | 3926 9091
 |  |  | PRO27 | CAT9 | Motor |  | HID16 | 3926 9099
 |  |  | PRO28 | CAT10 | Motor Support |  | HID17 | 4010 | V Belts
 |  |  | PRO29 | CAT10 | Others |  | HID18 | 4016 9330
 |  |  | [NAME] | CAT10 | Pulleys and V-belts |  | HID19 | 4415 | Packing wood
 |  |  | PRO31 | CAT10 | Shaft |  | HID20 | 4415 0000
 |  |  | [NAME] | CAT10 | Shaft-impeller assembly |  | HID21 | 4811
 |  |  | PRO33 | CAT7 | Silencers |  | HID22 | 4811 4100
 |  |  | PRO34 | CAT8 | Speed controller |  | HID23 | 4901 | Printed books, brochures, leaflets and similar printed matter, whether or not in single sheets
 |  |  | PRO35 | CAT7 | Taperlocks |  | HID24 | 6116 | Hand Gloves
 |  |  | PRO36 | CAT8 | Temperature probes |  | HID25 | 6310 | Cotton waste
 |  |  | PRO37 | CAT9 | Variable Frequency Drives |  | HID26 | 6805 | Emery Sheet
 |  |  | PRO38 | CAT8 | Vibration Sensors |  | HID27 | 6807 | Buffing wheel / Grinding wheel
 |  |  |  |  |  |  | HID28 | 7019 3100 | FRP Bell Mouth
 |  |  |  |  |  |  | HID29 | 7020 | [NAME]
 |  |  |  |  |  |  | HID30 | 7308
 |  |  |  |  |  |  | HID31 | 7318 | Fasteners
 |  |  |  |  |  |  | HID32 | 7325 | Shaft / Hub MachinIng
 |  |  |  |  |  |  | HID33 | 7610 9030
 |  |  |  |  |  |  | HID34 | 8205 | [NAME]
 |  |  |  |  |  |  | HID35 | 8207 | Drill Bits / Tap Set
 |  |  |  |  |  |  | HID36 | 8310 0090
 |  |  |  |  |  |  | HID37 | 8311 | Welding Electrodes
 |  |  |  |  |  |  | HID38 | 8414 1090
 |  |  |  |  |  |  | HID39 | 8414 5190
 |  |  |  |  |  |  | HID40 | 8414 5930 | Industrial Fans and Blowers
 |  |  |  |  |  |  | HID41 | 8414 9019
 |  |  |  |  |  |  | HID42 | 8414 9040 | Parts of Industrial fans and Blowers
 |  |  |  |  |  |  | HID43 | 8415
 |  |  |  |  |  |  | HID44 | 8421
 |  |  |  |  |  |  | HID45 | 8421 1100
 |  |  |  |  |  |  | HID46 | 8421 2900
 |  |  |  |  |  |  | HID47 | 8421 3990 | [NAME]
 |  |  |  |  |  |  | HID48 | 8434 4010
 |  |  |  |  |  |  | HID49 | 8479 6000
 |  |  |  |  |  |  | HID50 | 8482
 |  |  |  |  |  |  | HID51 | 8482 1012 | [NAME]
 |  |  |  |  |  |  | HID52 | 8482 3000 | Roller Bearing
 |  |  |  |  |  |  | HID53 | 8482 9900 | Adopter Sleeve
 |  |  |  |  |  |  | HID54 | 8483
 |  |  |  |  |  |  | HID55 | 8483 3000 | Plummer Block
 |  |  |  |  |  |  | HID56 | 8483 4000 | Pulleys
 |  |  |  |  |  |  | HID57 | 8483 4010
 |  |  |  |  |  |  | [NAME] | 8483 9000 | [NAME]
 |  |  |  |  |  |  | HID59 | 8484 1090 | Flexible Connection / damper
 |  |  |  |  |  |  | HID60 | 8487 9000 | Anti Vibration Mounts
 |  |  |  |  |  |  | HID61 | 8501 | Electric Motors
 |  |  |  |  |  |  | [NAME] | 8501 1020 | Electric Actuator
 |  |  |  |  |  |  | HID63 | 8501 51 | Modulating Electrical Actuator
 |  |  |  |  |  |  | HID64 | 8504
 |  |  |  |  |  |  | HID65 | 8504 4090
 |  |  |  |  |  |  | HID66 | 8536 5090 | Inductive Speed Sensor
 |  |  |  |  |  |  | HID67 | 8542 2100
 |  |  |  |  |  |  | HID68 | 8544 1190
 |  |  |  |  |  |  | HID69 | 8544 4999 | Connector with Cable
 |  |  |  |  |  |  | HID70 | 8605 | Grinding Stone
 |  |  |  |  |  |  | HID71 | 9004 | Goggles
 |  |  |  |  |  |  | HID72 | 9017
 |  |  |  |  |  |  | HID73 | 9025
 |  |  |  |  |  |  | HID74 | 9026
 |  |  |  |  |  |  | HID75 | 9031
 |  |  |  |  |  |  | HID76 | 9031 9000
 |  |  |  |  |  |  | HID77 | 9032 1090
 |  |  |  |  |  |  | HID78 | 9403 3090
 |  |  |  |  |  |  | HID79 | 9403 6000
 |  |  |  |  |  |  | HID80 | 9954 69
 |  |  |  |  |  |  | HID81 | 9966 01 | Rental services of road vehicles including buses, coaches, cars, trucks and other motor vehicles, with or without operator
 |  |  |  |  |  |  | HID82 | 9967 11 | Container handling services
 |  |  |  |  |  |  | HID83 | 9967 12 | Customs House Agent services
 |  |  |  |  |  |  | HID84 | 9967 19 | Other cargo and baggage handling services
 |  |  |  |  |  |  | HID85 | 9973
 |  |  |  |  |  |  | HID86 | 9985 19 | Other employment & labour supply services n.e.c
 |  |  |  |  |  |  | HID87 | 9985 95 | Specialized office support services such as duplicating services, mailing services, document preparation etc
 |  |  |  |  |  |  | HID88 | 9987 17
 |  |  |  |  |  |  | HID89 | 9987 19
 |  |  |  |  |  |  | HID90 | 9988 | Powder coating / Hot Dip Galvanizing Job work