Spreadsheet: 689575d1596526294-is-countif-the-correct-function-to-match-a-substring-in-a-range-to-a-selected-value-excelforum
Sheet: Vendors-for-Tally

S.No | VendID | Vendorname | [NAME] | CATID | Category
1 | A001 | Abro Technologies P. Ltd. |  | CAT2 | Capital Equipment
2 | A002 | Ace Engineering Technologies P. Ltd. |  | CAT2 | Capital Equipment
3 | A003 | Ace Power Products |  | CAT2 | Capital Equipment
4 | A004 | AD Enterprises | 29BEJPA0910B1Z8
5 | A005 | Advanced Industrial Solutions P. Ltd. | 33AAOCA6341F1ZT
6 | A006 | Adyar [NAME] India P. Ltd. | 29AAICA3787F1ZC | CAT5 | Establishment Expenses
7 | A007 | Ahmedia Enterprises
8 | A008 | Akshay Packaging Industries | 29AAEFA4953A1EZQ | CAT15 | Packing Materials and/ or Charges
9 | A009 | Alamdar Enterprises
10 | A010 | [NAME]
11 | A011 | Almonard P. Ltd.
12 | A012 | Aluminium Sales Corporation
13 | A013 | [NAME] | 29BEXPB9318G1ZZ
14 | A014 | Ankith Interiors | 29AIHPK5465G1ZY
15 | A015 | Anugraha Construction Technique Co LLP | 29ABLFA4978P1ZD
16 | A016 | Apollo Hospitals Enterprise Ltd. |  | CAT5 | Establishment Expenses
17 | A017 | Appario Retail P. Ltd. | 29AALCA0171E1ZV | CAT5 | Establishment Expenses
18 | A018 | Aqua Enterprises
19 | A019 | Aqua Services | 29ALMPR8501Q1Z4
20 | A020 | AR Karnataka Steel Traders
21 | A021 | Armes Maini Storage Systems P. Ltd. |  | CAT2 | Capital Equipment
22 | A022 | [NAME] systems | 29AOOPS8560D1ZB
23 | A023 | Axis Controls & Systems | 29AAOFA2516M1Z4
24 | A024 | Azmeera and Sons
25 | A025 | Ankom International | 29AGDPK6206D1ZO
26 | B001 | Belimo Actuators India P. Ltd. | 27AACCB7729E1ZP | CAT7 | Fan Accessories
27 | B002 | Benisha Enterprises
28 | B003 | [NAME] | 29AAIFB1136A1ZO
29 | B004 | Bombay Metal corporation
30 | B005 | Bombay Process Control
31 | B006 | Bright Tech Insulations | 29AGOPV7044B1Z0
32 | B007 | BSNL Bharat Sanchar Nigam Ltd. | 29AABCB5576GRZR | CAT1 | Business Services
33 | B008 | Buhariwala Logistics P Ltd. | 29AAFFB0409F1ZV | CAT3 | Clear & Forward
34 | B009 | Burhani Rubber Products
35 | B010 | [NAME] A
36 | C001 | [NAME]
37 | C002 | Caterpillar Cargo Solutions India P. Ltd. | 27AAECC1386Q1Z4 | CAT3 | Clear & Forward
38 | C003 | Coburg Engineering Services P. Ltd. | 29AADCC3847M1Z7 | CAT2 | Capital Equipment
39 | C004 | Comfort Link
40 | C005 | Comfort Sales Corporation | 29ABKPH4708B1ZV
41 | C006 | CWC ([NAME] | 27AAACC5849C1ZT | CAT3 | Clear & Forward
42 | D001 | D B Group India P. Ltd. | 27AACCD2938H1ZO | CAT3 | Clear & Forward
43 | D002 | Diagnostic Engineers | 29ACKPM4246J1Z6
44 | D003 | [NAME] Handling Equipments
45 | D004 | Divya Enterprises
46 | D005 | [NAME]
47 | D006 | Dynemech System P. Ltd. | 07AABCD4754E1ZV
48 | E001 | E & B Rubber Metal Products P. Ltd. | 06AACCE4119K1ZR
49 | E002 | Ellora Engineering Co.
50 | E003 | EMU Lines P. Ltd. | 27AAACE3803E1Z5 | CAT3 | Clear & Forward
51 | E004 | [NAME]. Ltd.
52 | E005 | Excel Enterprises
53 | F001 | FVI IMPORTS |  | CAT11 | Imports
54 | F002 | [NAME] | 29AACFF6463A1ZM | [NAME] | Fabrication
55 | F003 | Fedex |  | CAT3 | Clear & Forward
56 | F004 | Frenzelit India P. Ltd. | 29AACCF0576D1ZS
57 | G001 | G Amarnath
58 | G002 | G B M Manufacturiing P. Ltd.
59 | G003 | G K Enterprises
60 | G004 | G S Hardware & Paints
61 | G005 | Gautam Fibre Glass India P. Ltd.
62 | G006 | Getway Solutions | 23AAQPV5288H1Z0
63 | G007 | Globe Sales and Services
64 | G008 | Gupta Electricals | 29AAAFG7288A1ZE
65 | G009 | [NAME] and [NAME]
66 | H001 | [NAME] | 29ARCPM1123H1Z2 | CAT5 | Establishment Expenses
67 | H002 | [NAME] | 27AAXPP8471B1Z4
68 | H003 | Hello Cranes |  | CAT14 | Material Handling (and/or Labour charge)
69 | H004 | Hibatech Engineering Industries | 29BKOPS4780E1ZI
70 | H005 | Hindustan Hardware Craft
71 | H006 | Honey Lubricants
72 | H007 | Hope Farm Industries
73 | H008 | Hot Dip Galvanizers P. Ltd. | 29AAACH5313E1ZX | CAT13 | Job Work
74 | H009 | Hyrise Group | 29AVFPK5089D1ZC
75 | I001 | Infinity Freight Services P. Ltd. | 27AACCI9290D1ZG | CAT3 | Clear & Forward
76 | I002 | Insta Exhibitions P. Ltd. | 27AABCI1085P1Z7
77 | I003 | International Cargo Terminal P. Ltd. | 27AABCN9159M1ZT | CAT3 | Clear & Forward
78 | J001 | Jobil Tempo Service |  | CAT19 | Transport
79 | J002 | [NAME]
80 | J003 | Jumbo Distributors
81 | J004 | JWR Logistics P. Ltd. | 27AACCJ4352R1Z1 | CAT3 | Clear & Forward
82 | K001 | K G Store | 33AFDPN4107K1ZN
83 | K002 | K V Techno Engineers | 23AJTPR0770N1ZK
84 | K003 | [NAME] corporation
85 | K004 | [NAME]
86 | K005 | Krishna Fabricators |  | [NAME] | Fabrication
87 | K006 | Kruthi Computer Services Pvt. Ltd.
88 | K007 | Kusum Electricals
89 | L001 | Life Style International P.Ltd. |  | CAT5 | Establishment Expenses
90 | L002 | Lokesh Electricals P. Ltd. | 29AAACL5995N1ZM | CAT9 | Fan Motors and Motor Accessories
91 | M001 | M P Brothers- Mangalore
92 | M002 | M S Powder Coaters | 29AEZPM3477L1ZC
93 | M003 | Mahalakshmi Industries
94 | M004 | Mahaveer Packaging |  | CAT15 | Packing Materials and/ or Charges
95 | M005 | [NAME] and Electricals
96 | M006 | [NAME] | 29AKOPP6346G1ZK
97 | M007 | [NAME] and Travels
98 | M008 | Maruthi Engineering Industry (Electricals) | 29AIMPL2359P1ZE
99 | M009 | Mary Industries
100 | M010 | Matha Fabrication
101 | M011 | Medhini Engineering Services
102 | M012 | Metcraft Engineering
103 | M013 | MFS Wholesale P. Ltd. | 07AAKCM6764E1Z7
104 | N001 | Nafees Corporation | 29AAAPE1697B1Z0 | CAT4 | Consumables
105 | N002 | Nandi tools agencies
106 | N003 | Nandini Natura Coating | 29AAJFN7570M1ZG
107 | N004 | Neha Fibers | 29EPVPP5058L1ZM
108 | N005 | New Rajlakshmi Hardware & Electricals
109 | N006 | [NAME] |  | CAT5 | Establishment Expenses
110 | N007 | Nova Silk P. Ltd. | 29AAACN1757C1ZN
111 | N008 | Nextel Engineering | 29DYXPS1344M1ZC
112 | O001 | Office Needs
113 | O002 | Omega Industries
114 | O003 | Orchid Shipping P. Ltd. | 27AAACO4262B1ZU
115 | P001 | Pallet Corporation Inc | 29AAKFP6273E1ZW | CAT15 | Packing Materials and/ or Charges
116 | P002 | PAN Office Systems P. Ltd. | 29AAACP9337N1ZQ | CAT5 | Establishment Expenses
117 | P003 | Patel Electric Stores
118 | P004 | Pavan Machine Tools & Services India P Ltd.
119 | P005 | Pentonic Technologies | 29AJBPP9277C1ZV | CAT1 | Business Services
120 | P006 | Pixel Smart P. Ltd. | 29AAJCP0714E1ZL
121 | P007 | Pooja Electricals & Home Appliances
122 | P008 | Prakash Electricals
123 | P009 | Prime Computers |  | CAT1 | Business Services
124 | P010 | Pro Care Solutions | 29AECPM3621B1ZY | CAT1 | Business Services
125 | R001 | R Soft Solutions | 29AEIPR8030F1ZA | CAT1 | Business Services
126 | R002 | Raghu Ram wood works |  | CAT15 | Packing Materials and/ or Charges
127 | R003 | Raj Industrial Stores
128 | R004 | Raj Lakshmi Electricals and Hardware
129 | R005 | Ramchand and Co
130 | R006 | RHS Filters P. Ltd. | 29AAHCR4753M1ZP
131 | R007 | Right Engineers and Equipment India | 29AAECR0335C1ZR
132 | R008 | Rustopac India | 29AATFR5431M1ZE | CAT15 | Packing Materials and/ or Charges
133 | S001 | S K Agency | 27AANFS5040D1Z9 | CAT3 | Clear & Forward
134 | S002 | S K S Engineering | 29ADHFS4336B1Z4
135 | S003 | S R Enterprises | 29AAFFV8848J1ZB
136 | S004 | Safe Fire and Safety Services |  | CAT1 | Business Services
137 | S005 | Safe International Packers & Movers | 29AETPA5184L1ZU | CAT15 | Packing Materials and/ or Charges
138 | S006 | Salehsons and Company
139 | S007 | Saloc Technologies P. Ltd. | 29AACCS5176L1ZS | CAT9 | Fan Motors and Motor Accessories
140 | S008 | Sampurna Enterprises | 29ADMPH0137J1ZH
141 | S009 | SBP Groups
142 | S010 | Seabird Marine Services P. Ltd. | 27AACCS9869C1ZZ
143 | S011 | Seapac Systems | 29AABCF8893J1ZW | CAT15 | Packing Materials and/ or Charges
144 | S012 | [NAME] |  | [NAME] | Fabrication
145 | S013 | [NAME]
146 | S014 | [NAME]
147 | S015 | Shri Lalitha [NAME] | 29ABPFS7791E1ZD | CAT4 | Consumables
148 | S016 | Singlepeak Technologies | 24ACXFS1663E1ZU
149 | S017 | SKF India Ltd. |  | CAT7 | Fan Accessories
150 | S018 | SMIS  Instrumentation
151 | S019 | Soorya Industries
152 | S020 | Spectrum Business Associates | 06ABQPR6092L1ZT
153 | S021 | Speed Post Enterprises |  | CAT1 | Business Services
154 | S022 | SPM Instrument India P.Ltd. | 36AADCS2198D1ZD
155 | S023 | Sri Krishna Electricals and Hardware
156 | S024 | Sri Lakshmi Engineering | 29BREPS9333L1ZO
157 | S025 | [NAME] | 29AMHPP5918P3Z2 | CAT1 | Business Services
158 | S026 | Sri Veerabhadreshwara Security Services | 29AMHPP5918P4Z1 | CAT1 | Business Services
159 | S027 | Sri Venkateshwara Electricals | 29BGTPV2222H1ZW
160 | S028 | [NAME] Engineerings | 29ALCPM6189M1ZB
161 | S029 | Sritronix Instruments and Solutions | 29AABPU4623J1ZE
162 | S030 | Sukrata Engineering Services Pvt Ltd.
163 | S031 | Sunrise Enterprises |  | CAT15 | Packing Materials and/ or Charges
164 | S032 | Surya Wood Enterprises | 29DEVPM6256N1ZA
165 | T001 | TCI Express Ltd.,KA | 29AADCT0663J1Z4 | CAT19 | Transport
166 | T002 | TCI XPS |  | CAT19 | Transport
167 | T003 | Technos sprayon
168 | T004 | The New Ball Bearing Co | 29AAAFT7708G1Z0
169 | T005 | The New India Machinery Company | 37AABFT0965A1ZH
170 | T006 | The Shertallai Coir Mats & Matting Co
171 | T007 | TR Industries | 29AAOFT2180Q1Z9
172 | T008 | Transguard Security Services P. Ltd. | 29AAECT5670N1ZM | CAT1 | Business Services
173 | T009 | TTP Technologies P. Ltd. | 29AAACT7188B1Z6
174 | U001 | Union Press P. Ltd. |  | CAT1 | Business Services
175 | V001 | Varna Coats P. Ltd. | 29AADCV5715F1Z8
176 | V002 | Vashi Electricals P. Ltd. | 29AAACV1496Q1ZI
177 | V003 | [NAME] | 29AAFFV8848J1ZB
178 | V004 | [NAME]
179 | W001 | World One Instrumentation
180 | W002 | WTT Technology Services India P. Ltd. | 33AAACW7879GIZY | CAT1 | Business Services
181 | Z001 | 3MS Industries
182 | Z002 | 3S Life Safe Akademie | 29ADLPK6045M1ZY | CAT18 | Staff Welfare
Total